how to convert uppercase to proper name using update query

[AShi]

how to convert uppercase to proper name using update query

 

[Bob Barrows [MVP]]

how to convert uppercase to proper name using update query

It might not be perfect, but the StrConv() function will do this:

update ... set namefield = strconv(namefield,vbPropercase)

 

[ceesdatabase]

Hello Ashi,

Try this :

UPDATE tblTable SET fieldName = Left([fieldName],1) &
LCase(Right([fieldName],Len([fieldName])-1));

grtz

 

[ceesdatabase]

Nicely working when changing vbPropercase in 3

StrConv([fieldName];3)

 

[Bob Barrows [MVP]]

Oh, that's right: I forgot Jet would not have the benefit of the enums.

Nicely working when changing vbPropercase in 3

StrConv([fieldName];3)

It might not be perfect, but the StrConv() function will do this:

update ... set namefield = strconv(namefield,vbPropercase)

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.