insert punctuation

[princessinthetower]

This is a cleanup problem. I have some name records in this format:

firstname middlename lastname
Joan E James
Harold A Smith
Sandra Brown Taylor

I would like to add a period after the single initials in the middlename without affecting records will a full middlename. Is there a way of identifying a single-character middlename and adding the punctuation?

 

[tlbroadbent]

Try something like this.

Update TableName
Set MiddleName=MiddleName + '.'
Where Len(MiddleName)=1 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.