Stored Procedures - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Stored Procedures

Author

Topic

ckehrer
Starting Member

4 Posts

Posted - 2008-05-24 : 17:38:50

I trying to retrieve data from a primary table and bring it into a stored procedure as Upper Case without forcing it to Upper Case. I don't want the data to be changed in the primary table. Any help I can get I really appreciate it.

Thanks,

Charlie

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-24 : 18:09:44

what?Post your question clearly.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-25 : 01:02:56

quote:
Originally posted by ckehrer

I trying to retrieve data from a primary table and bring it into a stored procedure as Upper Case without forcing it to Upper Case. I don't want the data to be changed in the primary table. Any help I can get I really appreciate it.

Thanks,

Charlie

Is this what you're looking at? If not explain you requirement.

SELECT UPPER(YourField) FROM YourTable

ckehrer
Starting Member

4 Posts

Posted - 2008-05-25 : 08:03:59

Thank you for the reply. I'm trying to write a stored procedure that brings back: LastName, FirstName, Address1, City, State, Zip, from Students primary table. I would like to bring back the data all in upper case without forcing it to uppercase. Is this possible? I want the data to only change to upper case when being retrieved from the stored procedure. I don't want the primary table data to change to upper case.

Thanks

Charlie

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-25 : 09:51:08

quote:
Originally posted by ckehrer

Thank you for the reply. I'm trying to write a stored procedure that brings back: LastName, FirstName, Address1, City, State, Zip, from Students primary table. I would like to bring back the data all in upper case without forcing it to uppercase. Is this possible? I want the data to only change to upper case when being retrieved from the stored procedure. I don't want the primary table data to change to upper case.

Thanks

Charlie

Sure you can. Just do thid

SELECT UPPER(LastName), UPPER(FirstName), UPPER(Address1), UPPER(City), UPPER(State), UPPER(Zip) FROM Students

This will give you all fields in Students table in upper case and value itself wont change its current case in table.

ckehrer
Starting Member

4 Posts

Posted - 2008-05-25 : 10:42:27

Thank you so much, it works great.

Do you know ASP.NET?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-25 : 10:49:17