Wouldn't it be nice if there were such a thing as an OnExpand event on the set variable action...
i.e. you're building up a SQL UPDATE statement with a bunch of Automise variables in a Set Variable action and for each variable you would like to run a function against the variable to escape any disallowed characters like the apostrophe / single quote (') so values like "my favorite's" can be escaped to "my favorite''s" - now that would be very nice indeed. As it is I have to either build it up in a VBScript using a Global Script or create dozens of Replace Actions...
If anyone can think of another way of doing this with the current version (3.0.0.629), I'd appreciate hearing from you
TJ