Re: how to turn off case sensitive when sort

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 09:34:42 -0400

He said "...but how do I turn off switch to treat lower case and upper case
the same?" 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OHLpiydXEHA.2972@TK2MSFTNGP12.phx.gbl...
>     Column1 collate Latin1_General_CS_AI
Wouldn't you want CI as opposed to CS?  ;-)
-- 
http://www.aspfaq.com/
(Reverse address to reply.)

Relevant Pages

  • Re: update 2 fields problem
    ... as the SQL Server optimizer will usually generate the ... This changes if the subquery has to be duplicated. ... order in which matches are found depends on the execution plan, ... still be affected by the UPDATE statement and the new values for Column1 ...
    (microsoft.public.sqlserver.programming)
  • Re: Insert value from a while loop
    ... select column1, column2 ... SQL Server MVP ... Columnist, SQL Server Professional ... I need to INSERT values from the loop into another table. ...
    (microsoft.public.sqlserver.programming)
  • Re: select distinct record only if certain column not null
    ... For instance, lets say column1 is a sample set, ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)
  • Re: Date Query
    ... to display any records from the current date and greater then. ... SELECT Column1, Column2, ... ... I recommend posting to an Access group. ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: select distinct record only if certain column not null
    ... For instance, lets say column1 is a sample set, ... SQL Server you are using. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)