Propercase in tables

[Picasso]

i know that its possible to do sentence case string converstions in ACCESS
using STRCONV([],3)

but is there any way that i can do this in SQL Server using SQL Analyzer?
all i can find is the LOWER - and UPPER functions?
i need to make JOHN SMITH - John Smith

can this be done in SQL server?

 

[i_takeuti]

i know that its possible to do sentence case string converstions in ACCESS
using STRCONV([],3)

but is there any way that i can do this in SQL Server using SQL Analyzer?
all i can find is the LOWER - and UPPER functions?
i need to make JOHN SMITH - John Smith

can this be done in SQL server?