Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 9:27 AM
Points: 6,800, Visits: 1,917
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/aw

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

Scott




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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:26 PM
Points: 157, Visits: 374
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