View Single Post
04-05-2008, 08:12 PM
Join Date: Apr 2008
Originally Posted by
If I understand what you are suggesting... word being the entered string and blah_field being the database entry. || allows you to concatenate strings. To search for the % you need to place an escape, usually \
where word like ('%'||blah_field)
Should do the trick.
You are instantly and permanently my favorite person.
I had to use CONCAT but the details you gave me helped me solve it within minutes!
View Public Profile
Send a private message to johnN
Find More Posts by johnN