case empty string

[BillTalada]

This is simplified but I like to cycle through options in sqlserver such as ON/OFF, True/False, and so on but I'm having trouble converting two single quotes to the word NULL. By the way, if anyone can write a useful, practical book on Quick Macros I'll pay $100.

Macro Macro1
Trigger Am     

Code:

Copy      Help

key CSL
key Cc
str s.getsel
str b

b = s

out b

;cycle thru groups
sel b 9
,case "ON": b="OFF"
,case "OFF": b="ON"
,case "True" : b="False"
,case "False" : b="True"
,case "NULL" : b="[39][39]"
,case "''" : b="NULL"

out b

b.setsel