tlist_sql select with quote in string

I'm trying to fix a problem encountered while using tlist_sql. The parameter ~[v.hrteacher] is being used in the select statement. It works as long as the teacher does not have a single quote in his/her name, but it fails when that occurs.
I have tried numerous methods, such as the replace() function, and the q'[]' function to remove the quote, but none has fixed the problem. Any suggestions?

Thanks,
Tom Bradford
SC Lexington School District 1