I want to specify the data in columns are both upper & lower case(i.e. one column data having all lowercase data or uppercase data ).
Ex:- if i have one column - col1 and its
1st value is RAKESH JHA
2nd value is rakesh jha
then how i can find that, how much row are in upper case. respectively lower case
Case - Sensitive field
Vanna
Use UPPER and LOWER functions. Like:
select * from MyTable where UPPER(fCOL1)=fCOL1
tanha
Have a look at
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm