Propercase columns

[Picasso]

Dnt know if this is the right group to ask this question in...

i need to 'sentence case' data in my SQL server tables. There is a statement
to put the whole field in lower- or uppercase but this is not what i need to
do. eg.

'JOHN SMITH' i need to convert to 'John Smith'

is this possible in SQL server using the SQL query analyzer?

 

[John]

Dnt know if this is the right group to ask this question in...

i need to 'sentence case' data in my SQL server tables. There is a statement
to put the whole field in lower- or uppercase but this is not what i need to
do. eg.

'JOHN SMITH' i need to convert to 'John Smith'

is this possible in SQL server using the SQL query analyzer?

Picasso,
Well now you know, this is the wrong newsgroup. This newsgroup is
dedicated to questions/issues about Microsoft Project, a planning and
scheduling application. I suggest you find a group that deals with SQL
Server.

John
Project MVP