Upper Case Query 2

[kchaudhry]

Hi,

I am using SQL Server 2000. I have a field in the table which has value "do not close". In some cases the data is lower case and then in other cases it is upper case. I want to write a query to only return the upper case instances. Can someone please help me with this?

Thanks,

Kchaudhry

 

[sunila7]

Try this ....

select * from tblname
where cast(fldname as varbinary) = cast (upper(fldname) as varbinary)




Sunil

 

[kchaudhry]

Thanks Sunil

Kchaudhry