• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

update query for reformating field contents

Experts:

There is a requirement to change the formating of text names for 13,000 plus records. Currently all the names are in upper case - but we would like to have the first letter Ucase and the rest Lowercase. How would one write an update query to do this. Or perhaps there is some other method one could employ.

Brad
0
B_P_B
Asked:
B_P_B
1 Solution
 
adatheladCommented:
UPDATE TableName
SET FieldName = UPPER(LEFT(FieldName, 1)) + LOWER(RIGHT(FieldName, LEN(FieldName) - 1))
WHERE LEN(FieldName) > 0
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now