in my table i have values 'FAHEEM' and 'faheem',Now i have to select 'faheem' but SQL treat both as same ,
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).
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.
Andras Belokosztolszki, MCPD, PhD