Monday, May 7, 2001 04:19 AM
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.