convert SQL to a vbb (or c#) string statement
in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
select * from atable
where a = 'FREE'
this would be converted to
SQL = "select * from atable"
sql =sql & "where a = 'FREE'"
this is then pasted into the clipboard
it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad cannot perform miracles) I used to use this a LOT!