There's a table with a field or column that has a person's name in it. It's in the format as follows:
Disregard that that's not normalized. Have to put up with it. Is there function in SQL that would me do a query on that field in the following format?:
It is wthout the comma Need a function embedded in the SQL select statement that formats the person's name in the latter format. Using ORACLE. Would prefer not to use any Oracle functions -- just standard SQL.