Hi, I have been trying to find a function in Ms SQL 2000 to pick up records that match exactly to a string in lowercase. So far, I found that Query Analyser that works closely with the MS SQL Server2000 converts any lowercase values and displays it in uppercase thereby not producing the match required. When I made a query via the "Query" method (using Enterprise Manager) to display a table, it displays the values in both uppercase and lowercase, meaning the actual content was either stored in upper or lower case as the case may be, and not forced to be stored in any particular case, hence displayed as they were stored. Because of that, I just want to display only the records that were stored in lowercase but not those records stored in uppercase. Sounds simple isn't it? There must be a way, I have not found out yet. Anyone have cracked this before? I will appreciate if you can share how you do it. Thank you in advance.