UPPERCASE

Question

Post reply

UPPERCASE

ash0550

Mr or Mrs. 500

Points: 517
More actions
June 9, 2011 at 10:48 am

#237706

When I am trying to use The UCASE as in MySql IN SQLSERVER it says it is not a predefined function.
SO instead what Should I do so that the data would be changing to UPPERCASE letters

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

wagnerbianchijr SSC Journeyman Points: 80 More actions · Answer 1

SELECT UPPER('name') as Name

GO

=> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718

Knowing my objectives, feeling the road's flavors. :w00t:

ash0550 Mr or Mrs. 500 Points: 517 More actions · Answer 2

wagnerbianchijr (6/9/2011)

SELECT UPPER('name') as Name

GO

=> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718%5B/quote%5D

yup thannks

it worked

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 3

Some of the most powerful tools in any computer language are found in the built in functions. UPPER is a pretty easy one to miss. My recommendation would be that you curl up with Books Online (the help system that comes with SQL Server) and at least familiarize yourself with all the functions. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)