UltraEdit can be programmed to:
- Highlight key words, comments & functions
- Indentation & linefeeds can be inserted using macros.
- Notice that inappropriate use of keywords jumps right out: ORDER is a keyword.
Easier to Read: I find this formatted SQL much easier to read.
Copy & Paste: Modified SQL can be pasted back into Access without problems. Of course the formatting is lost after Access strips it away on saving the SQL.
Comments: I coded "--" as a comment prefix as in SQL Server t-SQL, for documenting. Of course the "--" comments must be stripped out before use in Access. Comments are useful for sample SQL saved for software engineering journal notes.