problem with comma's in SQL

[dharkangel]

I have this SQL statement that is throwing an error saying there is a comma in the query expression. The problem is that is the way the data is in the database. the 'UserName' variable looks like this:

Smith, Jane
Doe, John

And so does the [Assigned To] variable

MySQL = "SELECT [Issue ID] FROM QPTActions WHERE [Assigned To] = " & UserName & ";"

How can I get around this?

Thank you.

 

[gmmastros]

Apostrophes!

MySQL = "SELECT [Issue ID] FROM QPTActions WHERE [Assigned To] = '" & Replace(UserName, "'", "''") & "';"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dharkangel]

thank you