Sunday, April 29, 2001 02:34 PM
What is the exact syntax for specifying a SQL LIKE query using wildcards (i'd like to add the wildcards in the actual query). I'm thinking of something like:
" WHERE FIRSTNAME LIKE :firstname% "
where :firstname is the parameter for my finder method and the * will be applied to the string.
I'm using Borland/Inprise AppServer 4.5.