Add Apostrophe To Column In Result Set

I have a brain teaser for you all.





The end result: I need one of the columns in my result set (col2) to have a preceeding apostrophe (i.e., '001234 ).





The problem: I am building my query as a string and then using the EXEC() function to execute it. For example:


SET @strSQL = 'SELECT col1, col2 FROM mytable'


EXEC(@strSQL)





Just to tame any answers that might not be directed to the specific question, the query Must be built as a string and then executed.





I have been unable to obtain the solution and I am wondering if it is even possible?





TIA