Uppercase to ProperCase Update Query needed

[Bikini Browser]

I need a query written that will change everything in one Column in One
table to Propercase versus upper case.

How do you do that? (I am not a programmer but I know how to paste a query
to the right spot.)

Thanks


Dale

 

[Guest]

UPDATE [TableName]
SET [TableName].[FIELD_NAME] = StrConv([FIELD_NAME],3);

 

[bmarland]

SELECT StrConv([field to make proper],3) AS Expr1
FROM [table to make proper];