A
AShi
how to convert uppercase to proper name using update query
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Barrows [MVP]
AShi said: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)
C
ceesdatabase
Hello Ashi,
Try this :
UPDATE tblTable SET fieldName = Left([fieldName],1) &
LCase(Right([fieldName],Len([fieldName])-1));
grtz
Try this :
UPDATE tblTable SET fieldName = Left([fieldName],1) &
LCase(Right([fieldName],Len([fieldName])-1));
grtz
C
ceesdatabase
Nicely working when changing vbPropercase in 3
StrConv([fieldName];3)
StrConv([fieldName];3)
B
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)
Bob Barrows said: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.