Guest
I'm new to SQL, so please bear with me...
database = "users"
table = "info"
field = "name"
I have a situation where data in the "name" field is in the form of:
LastName, FirstName MiddleInitial.
I need to change it to the following form:
FirstName MiddleInitial. LastName
And then I need to update each row to fit the new form.
How can I do that in a SQL query?
I would really appreciate anyone's help or direction in finding out how to
do this.
Thanks,
Hobbster
database = "users"
table = "info"
field = "name"
I have a situation where data in the "name" field is in the form of:
LastName, FirstName MiddleInitial.
I need to change it to the following form:
FirstName MiddleInitial. LastName
And then I need to update each row to fit the new form.
How can I do that in a SQL query?
I would really appreciate anyone's help or direction in finding out how to
do this.
Thanks,
Hobbster
