I don’t know if this is even possible, but I’m going to ask anyway.
I have been tasked to clean up yet another section’s database. While attempting to run an outer join with another DB using the name field, I discovered it wouldn’t work.
It wouldn’t work because the DB I’m attempting to clean up is in a sorry state due to non-consistency in how they enter data.
They have entered many names like this:
Yup, just like that. No spaces and commas where you’re seeing them in the example above. Additionally, they’re not being consistent. Not all names are entered this way, just about fifty percent of them.
The other DB has the name field entered thusly:
LAST NAME,FIRST NAME MI
As this data is pulled from a big DB in the sky, this is the format we need to use.
Is there away to input a mask or format for the name field in the FUBARRED DB and dummy proof it?
I see there are input formats for dates, SSNs, etc, but nothing for a name.
I’ve tried many different things using the SQL view and nothing works. Am I SOL?