Update Query

[mhm181]

Update Query to Convert Text to Proper Case

i want to create an update qry to update the "patient" full names to be UpperCase . any help on this issue?

 

[gromit]

Hi -

Use the UCase function. E.g.

CapsName = UCase(PatientName)

- g

 

[Pat Hartman]

UCase() converts text to all upper case. The correct function is strConv().

Update YourTable Set NameField = strConv(NameField,3);

As always, make a back up before running untested updates.

 

[mhm181]

thanks to both of you. i need both
thanks again

 

[Bigmo2u]

Pat - I hate to bring this to the top again but I tried the

NameField = strConv(NameField,3)

LName = strConv([LNAME],3)

When I run the query as a select query I get -1.

Could you please tell me what I am doing wrong.

Your help is greatly appreciated.

 

[Bigmo2u]

Sorry to bother you guys on this. I found my error:

Expr: StrConv([LName],3)

 

[rhett7660]

Just what I was looking for..

Thanks!
R~