How can I specify a SQL LIKE query in an CMP Entity Bean using Inprise AppServer
0 posts in topic
Flat View  Flat View

Posted By:   John_Heart
Posted On:   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.

About | Sitemap | Contact