![]() |
Help needed on LIKE statement
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 |
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%' |
All times are GMT. The time now is 11:22 AM. |
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com