SQLServerCentral / Discuss Content Posted by Andy Warren / Article Discussions / Article Discussions by Author / Case Sensitivity in Selects - Part 3 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 00:34:07 GMT20RE: Case Sensitivity in Selects - Part 3http://www.sqlservercentral.com/Forums/Topic119672-29-1.aspxHmm... 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...).Tue, 06 Jul 2004 02:58:00 GMTcorey lawsonRE: Case Sensitivity in Selects - Part 3http://www.sqlservercentral.com/Forums/Topic119672-29-1.aspx<P>Great article - but I can't find part 2...</P><P>Scott</P>Mon, 14 Jun 2004 23:22:00 GMTbredinsCase Sensitivity in Selects - Part 3http://www.sqlservercentral.com/Forums/Topic119672-29-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/awarren/casesensitivityinselectspart3.asp>http://www.sqlservercentral.com/columnists/awMon, 07 Jun 2004 13:55:00 GMTAndy Warren