Dear Sir / Madam,
This question is for anyone who can help me out of
this situation. How do I perform a case insensitive
search in a SQL ?
I refer to Mr Chris J Lu's question in InstantDB :
How to search a name = "David" or "david" or "DAVID"
or "DAvid"
from a table (address). What is the SQL ?
SELECT * from address where name="david" (Ignore case)
??
Please let me know.
Thank You
regards
Ravindra Janapareddy
Software Programmer
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|