faheemlatif (3/10/2008)
Hi ,in my table i have values 'FAHEEM' and 'faheem',Now i have to select 'faheem' but SQL treat both as same ,
PLz suggest.
You could also use the COLLATE keyword (e.g. if you do not want binary comparison, you still want to compare the strings based on language rules).
example:
select 1 where 'FAHEEM' = 'faheem' COLLATE SQL_Latin1_General_Cp1_CS_AS
The above will use the Latin1 collation with case sensitivity and accent sensitivity.
Regards,
Andras