CASE sensitive | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

CASE sensitive

How can I get Lastname and Firstname in Upper case or Lower Case in the result set. Thanks!
"He laughs best who laughs last"
Do you mean the result set of a query? As in select upper(‘a’)
select lower(‘B’) ? John
yeah am not concerned how the data is in DB but when i run query if i need the result set in upper/lower case, which ever i need. just want to select and display Thanks!
"He laughs best who laughs last"
anyways thanks
I got it.
Thanks!
"He laughs best who laughs last"
Reddy, some of your questions seem easy. You should check out functions in sql server help file for more functions Madhivanan Failing to plan is Planning to fail
]]>