This
utility takes ASCII source code and performs the following operations
- It substitutes HTML entities for all non-ascii characters and HTML reserved characters
- It colour-codes the SQL according to the classic style of the Query Analyser
- It substitutes hard spaces for tabs
- it converts all SQL Keywords to upper case
All you need to do is to paste your code in the SQL window, and the results are rendered in the results window. You can click between the windows using the tabs.
SELECT c.*, s.*
FROM tblasd c
left outer join tblS s on s.St = c.Ct
where Office ='London'
order by s.St, c.ca
Becomes......
SELECT c.*, s.*
FROM tblasd c
LEFT OUTER JOIN tblS s ON s.St = c.Ct
WHERE Office ='London'
ORDER BY s.St, c.ca