Re: Case Sensitive

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tenaya (ct_at_ct.ct)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 16:37:32 -0500

Atley,

Please search the SQL Server 2000 Books Online re: "COLLATE" and
"COLLATIONS" to understand why you are getting different results on the
different SQL Server instances.

To help you out immediately, however, the following is an example of how to
use the COLLATE syntax within a SELECT:

create table Atley (c1 char (1) NOT NULL)
go

insert into Atley values ('m')
insert into Atley values ('M')

select *
from Atley
where c1 = 'm' collate Latin1_General_CS_AS

Chief Tenaya

"Atley" <atley_1@homtmail.com> wrote in message
news:uwl89FFEEHA.3696@TK2MSFTNGP10.phx.gbl...
> I have a table that has a field populated by single character data.
>
> in it 'm' is different than 'M'. How do I differentiate this in my
> queries....
>
> It works automatically on my base SQL server, but not on the replicant.
>
>
>
> Thanks for the help...
>
>
>

Relevant Pages

  • Re: Case Sensitive
    ... different SQL Server instances. ... use the COLLATE syntax within a SELECT: ... create table Atley NOT NULL) ...
    (microsoft.public.sqlserver.replication)
  • Re: Case Sensitive
    ... different SQL Server instances. ... use the COLLATE syntax within a SELECT: ... create table Atley NOT NULL) ...
    (microsoft.public.sqlserver.programming)
  • Re: Works fine in SQL 7 but not in SQL 2K
    ... you will get an estimated graphical showplan. ... I'd also take your query and feed it to ... Columnist, SQL Server Professional ... COLLATE ...
    (microsoft.public.sqlserver.server)
  • Re: ASCII lookup table
    ... I am sorry I am not familar with SQL Server very much. ... Based on my discussion with a SQL team engineer, the COLLATE is also ... Microsoft Online Partner Support ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problem converting to a date...
    ... SQL Server MVP ... Columnist, SQL Server Professional ... "Atley" wrote in message ... low impact method for converting this to a useable date ...
    (microsoft.public.sqlserver.datamining)