I'm constructing a SQL string that needs single quotes in the WHERE clause. How do I encapsulate them in a string variable. I looked into ESCAPE and SET QUOTED_IDENTIFIER, but i don't really see any examples using string Concatenation. I'm trying to filter out the zls (0 length strings)
The color hint feedback that SQL Analyzer gives you helped a lot, I just kept typing quotes until the colors looked good. I found when you're in the middle of a string, 2 singles: 'SELECT ''MyVal'' FROM kludge', when you get to the ends of strings and start to work in some vars, it gets weird.
If there is a rule, I wish I knew it, this seems more like a black art, as if those who persist will be rewarded. In most IDEs I can do it in my sleep because you have the double quotes to delimit.