Don't Want Keyword Formatting in Literal String

kenelm

I just upgraded to V5 of SQL Prompt. I had been told previously by RedGate support that keyword formatting, such as turning to upper case, inside a literal string had been fixed in V5. I'm still seeing it. If I'm in a literal and type "on" or "when" etc., SQL Prompt reformats to ON and WHEN. I don't want this to happen inside a literal.

Can you tell me if there's a setting I'm missing to turn this off, or if this is supposed to be fixed, or will be fixed?

I'm running 5.0.1.7

aolcot

I've just tried doing this using version 5.1.6.35 and when inside a literal string, keywords are not being converted to upper case.

e.g. i typed this out all in lowercase and let sql prompt do the formatting without any tweaks from me.

SELECT * FROM sys.tables WHERE name = 'on when'

I don't recall changing anything in particular within the options.

Hope this helps in some way.