*= Notation in 2005

Hi,
I've heard a rumour that the *= notation is no longer supported in SQL
Server 2005. I've searched through the knowledge base but can't find any
articles on it. If anybody who currently has 2005 could confirm whether it
is or isn't supported that would be great.
Thanks,
David.
Hi David,
*= and =* are NON-ANSI standard LEFT and RIGHT OUTER joins. THis is
supported only in the compatibility level 80 (SQL 2000) and lower versions.
If the database compatibility is 90 (SQL 2005) then you may need to right
the query using LEFT OUTER JOIN or RIGHT OUTER JOIN.
Thanks
Hari
"David" <David@.discussions.microsoft.com> wrote in message
news:6E05EAFB-595B-4E64-9267-563A825B0644@.microsoft.com...
> Hi,
> I've heard a rumour that the *= notation is no longer supported in SQL
> Server 2005. I've searched through the knowledge base but can't find any
> articles on it. If anybody who currently has 2005 could confirm whether
> it
> is or isn't supported that would be great.
> Thanks,
> David.
>