Help with UPPER function - 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 2000 Forums

SQL Server Development (2000)

Help with UPPER function

Author

Topic

0341
Starting Member

21 Posts

Posted - 2008-09-11 : 16:46:37

When I run this

select CAST(au_lname +', '+ au_fname AS varchar(20))
from authors
where au_lname = 'ropp'

I get this
ropp, phillip

How do I get it to read

Ropp, Phillip

without updating the record

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-09-11 : 17:06:23

see if any of these help:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104351
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106425

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources