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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-10 : 00:46:46
|
| Phil writes "Is there a method of changing a character field containing lower case characters into Sentence case(Proper case / Title case). ie phil toop to Phil Toop. Specifically to amend an address line to print correctly on bills." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-06-10 : 01:45:51
|
| Therez no such in built function with SQL Server. but you do it using the other string functions.Check this http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=15152 .HTH-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
|
|
|
Changing lower case fields to Sentence case