[dba-SQLServer] Cannot sort on Abs([Field]=0)

Hi all

This works in Access SQL:

  ORDER BY Abs([SortOrder]=0)

but if the tables are linked via ODBC to SQL Server 2008, it fails:

  Incorrect syntax near '='. (#102)

I have to rewrite it like this:

  ORDER BY Abs(CBool([SortOrder]=0))

Why is that? [SortOrder] is a short integer with no Nulls.

/gustav