I am working on a stored procedure which requires appending a single quote to a variable string, but SQL treats strings enclosed in single quotes. Can anyone teach me how to represent single quote to allow my procedure to insert single quotes?
I have tried the below: 1. SET @var = ''' 2. SET @var = "'" 3. SET @var = convert(varchar,"'")
obviously 1 will not work, and 2 and 3 returns invalid column name '''.