Adaptive Server Enterprise does not support aliases in a where clause

[CR #446291] An error displays when using a alias of a field name in a SQL where clause.

Workaround: Use the actual field name in the SQL where clause and the query runs correctly.