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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jDanM
  • Order by date
  1. jDanM

    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...
  2. jDanM

    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 =...

Part and Inventory Search

Back
Top