Multipart Fields problem 2

[mraetrudeaujr]

I have a problem. I have a shift leader (user) that I cannot convince that it is a data integrity risk to allow this field condition. Also, all of the users are entering their data directly into the table. I have conveyed this to my supervisor (about the urgency to begin using a 'Form' interface), and he understands this need. However as stated above, I have a shift leader that insists on doing all of his searching, editing, and entering of information through the database. All I am doing is looking for a temporary fix in preparation for our transition to an Oracle Server.

First, I would like to have a really good (plain English) reason to give him (them) that explains why this is a bad practice.

Second, how would I go about 'splitting' this multipart information? Obviously I could do it manually, but then we have over 10,000 records that would need this. Is there a query that would parse this out?

Thanks in advance.

 

[mraetrudeaujr]

...more; 'Syntax error in the UPDATE statement'. I hope this helps a little more.

 

[mraetrudeaujr]

Could part of my problem be because some names were listed like "Jose de Jesus" (e.g. three 'values')?