Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB2 case-insensitive search
Price is actually a varchar field. I've found out that the long varchar field is the one giving trouble- "NOTES". I've built a workaround at the moment to check for the uppercase, lowercase and proper case of any search term, but that's a little novice. If you have any ideas on how to work... -
DB2 case-insensitive search
I am trying to use Upper() or Lower() combined with VBscript ucase/lcase to perform a case-insensitive search on DB2. My script produces SQL like the following: Select * From INFO, Sources, Banks, Services, Verify, Importance WHERE Verify.VerifyID = Info.Quality AND Importance.ImportanceID =...
