as far as i know, SQL Server is not case sensitive for text comparision, so just compare like select * from t where xyz = 'abc' or select * from t where xyz = 'ABC' both are same. 'Sunday' and 'SUNDAY' are same in SQL Server. or if you want to make sure than you can use either UPPER() or LOWER() i.e. select * from t where upper(xyz) = 'ABC' Also Manas is trying to tell you that if you want to do partial search then use 'Like' with '%' ex. select * from t where Day like 'S%' will return both 'Saturday' and 'Sunday' while select * from t where Day like 'Su%'; will return only 'Sunday' in short % is like * in DOS.
modified on Tuesday, September 9, 2008 12:48 PM