Proper Case - 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

General SQL Server Forums

New to SQL Server Programming

Proper Case

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2009-12-22 : 15:25:47

Do we have any function where we can use proper case.

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-12-22 : 15:39:36

Nothing built in I think...

But you should find your answer here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-22 : 15:40:13

There is no built-in function to do it, but several people have written functions so I'd suggest searching for them here.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-12-22 : 15:41:34

Not sure what the question is - but you can:
- specify a case sensitive collation to define a column or even just to compare values
- use functions UPPER and LOWER to convert case

What are you trying to do?

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources