Don't want it to be necessary for exact string to be typed into search box.

Hey folks - I currently have code written for a search box. Unfortunately, it requires the exact string to be inputted in order for a row to be populated. In an ID, there could be "ID_AB_24" or "ID1_AB_32" or "AB_24". I would want for people to be able to simply type in AB_24 or AB_32 and still have it populated. Is there a way to do this? It's currently case-insensitive, and I'd like it to stay that way.

Thanks!

Please Login or Register  to view this content.

Hi,

You might want to try comparisons using the 'Like' command:

Please Login or Register  to view this content.

For additional information see:
http://msdn.microsoft.com/en-us/library/swf8kaxw.aspx
http://msdn.microsoft.com/en-us/library/8t3khw5f.aspx

Lewis