I like the idea of using variables instead of the quotes. But not the part about the ASCII characters. The solution below works best for me:
Declare @q char(1)
Set @q = ''''
The value in the Set statement is four (4) characters, all single quotes.
Bob Monahon