Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Case Sensitivity in Selects - Part 3 Expand / Collapse
Posted Monday, June 7, 2004 1:55 PM


Group: Moderators
Last Login: Today @ 1:07 PM
Points: 7,062, Visits: 2,667
Comments posted to this topic are about the content posted at

SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #119672
Posted Monday, June 14, 2004 11:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 1:20 PM
Points: 36, Visits: 40

Great article - but I can't find part 2...


Post #121021
Posted Tuesday, July 6, 2004 2:58 AM


Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 189, Visits: 539
Hmm... there are the NLSSORT and NLS_SORT functions to try as well...

As far as case-insentive searches and indexes... unless you're hitting a desktop database like Access, you probably can code an insert trigger on the table that will force the value being added to be Upper case (Upper() is an ANSI-standard sql function...).

Post #124816
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse