Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Changing Case?

Author  Topic 

youruseridistoxic
Yak Posting Veteran

65 Posts

Posted - 2008-09-17 : 09:15:34
When executing a query against multiple tables, is there a method by which I can mask the result-set (more specifically, the data from 1 particular column) to Upper Case?


Thanks

cardgunner

326 Posts

Posted - 2008-09-17 : 09:25:04
I think you are looking for upper(your_column).

That converts them to uppercase

CardGunner
Go to Top of Page

youruseridistoxic
Yak Posting Veteran

65 Posts

Posted - 2008-09-17 : 11:24:21
quote:
Originally posted by cardgunner

I think you are looking for upper(your_column).

That converts them to uppercase

CardGunner



This is exactly what I needed - many thanks!
Go to Top of Page
   

- Advertisement -