Wednesday, May 9, 2001 11:46 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, so that for firstname="John" the resulting query will be
"SELECT ... WHERE FIRSTNAME LIKE 'John%'"
I'm using Borland/Inprise AppServer 4.5.