Uppercase to ProperCase Update Query needed

  • Thread starter Thread starter Bikini Browser
  • Start date Start date
B

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
 
UPDATE [TableName]
SET [TableName].[FIELD_NAME] = StrConv([FIELD_NAME],3);
 
SELECT StrConv([field to make proper],3) AS Expr1
FROM [table to make proper];
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Way to query both ProperCase & Upper Case 4
ProperCase 9
UpperCase to ProperCase and Back again 3
Update query with greek characters 8
update query with greek characters 4
Excel - stop automatically changing mixture of uppercase and lowercase to propercase 2
UpperCase to ProperCase 2
Simple update query question 3

Back
Top