Remove Middle Initial from Name field sql query
Posted on 2014-01-03
Good Afternoon Experts,
I have another question, I am using a name column in a query. The name shows like this
Lastname, Firstname MI. Not all fields have a middle initial, how would I trim the middle initial from the field?
for example I have
Brown, Sandy L
Puz, Karen R