I’m using the following query to search by TITLE in the CDSTORE database, but the search is not case insensitive. How to make the search case insensitive? I thought about using the LOWER verb but I guess it is not defined by the BBj SQL engine.
SELECT TITLE, MUSICTYPE FROM CDINVENTORY WHERE TITLE LIKE '%s%' ORDER BY MUSICTYPE
>Solution :
I believe BBj doesn’t support the LOWER verb, but instead, you could the integrated CVS Function to the exact same thing. The following should be what you are looking for:
SELECT TITLE, MUSICTYPE FROM CDINVENTORY WHERE cvs(TITLE,8) LIKE '%s%' ORDER BY MUSICTYPE
You’ll find more information about the CVS function
here