remove comma from string in query (1 Viewer)

[dhx10000]

I have this query:

INSERT INTO 1_2_06 ( Issue_ID, Assigned_To, ListType )
SELECT Issue_ID, Assigned_To, 'QPT'
FROM QPTActions
WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006');

The Assigned_To values are a Lastname, Firstname format as they come out of the first database. But I need the comma stripped before they get entered into the INSERT database. Is it possible to do this on the fly?

 

[RV]

You really should use separate columns for Lastname and Firstname.
If you persist in your question, use the Replace function.

RV

 

[dhx10000]

Thank you, this works great. Unfortunately, I have to compare the Assigned_To field to another Assigned_To field that is setup this way (Lastname, Firstname). I have to be able to make exact matches on this data. Otherwise, I would definitely separate it, but I have no control over the data I am being given.