View Full Version : Help needed on LIKE statement

01-06-2012, 10:57 AM

I have created a search from with 3 different fields.

I wanted the search results with LIKE statements from a table.

I am confused how to add LIKE statement in query with % wild card.

Results are coming only when i add WHERE clause as "=" but not with %.

Can some body guide me how to insert LIKE statement with % wild cared in dream weaver recordset.


01-07-2012, 01:13 AM
you may have to hand code that , im not certain but i think it maybe a quirk using it in the dreamweaver wizard, but i am far from certain.
I mat regret this as i hate trying to modify dreamweaver code but post the code, if you cant add wild card use + and ill see if i can help. A typical sql statement would be something resembling

WHERE FirstName LIKE 'S%'