• Yes, you do have a tool for fixing queries. Not automatically everything all at once in your system, but for one query at a time, the "design query in editor" tool will do the conversion in most cases.

    There are several ways to get to this tool, but I usually just paste my offending query (with a *= or =*) into sql query analyzer. I highlight the complete query. Then click ctrl + shift + q. This will open the query design tool, with the entire query rewritten using ansi join operators.

    I usually just copy the from and where clauses from there, and paste them back into my source. So far, it's working great.