Convert first character of a string to Upper Case

[Bwintech]

Hi,

I have a list of names and I want to run a script that will update the first character to be upper case, I have tried this but get an error:

update students
set substring(name,1,1) = UPPER(substring(name,1,1))

How else can I do this?

Many thanks for your help

 

[bperry]

Will this work? (untested)

update students
set name = UPPER(substring(name,1,1))
+ substring(name,2,LEN(NAME))

 

[bperry]

P.S.
Strictly speaking, I guess, we should actually subtract 1 from the overall length:

update students
set name = UPPER(substring(name,1,1))
+ substring(name,2,LEN(NAME) -1)

But I find it seems to works exactly the same without it.

rgrds, etc
bp

 

[tlbroadbent]

If you are interested in converting a full name to Proper case see thread183-253516. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.