Case Sensitivity in Selects

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Case Sensitivity in Selects - Part 3

Case Sensitivity in Selects - Part 3

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Monday, June 07, 2004 1:55 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/aw

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #119672

bredins

Posted Monday, June 14, 2004 11:22 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 1:20 PM
Points: 36, Visits: 40

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

Scott

Post #121021

corey lawson

Posted Tuesday, July 06, 2004 2:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:10 PM
Points: 135, Visits: 205

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 »

Permissions