PDA

View Full Version : Help needed on LIKE statement


clearwaters
01-06-2012, 09:57 AM
Hi,

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.

Thanks

edbr
01-07-2012, 12: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%'