Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't use temporary column in where clause?

Tags:

select  cast(de.ApprovalOrder AS VARCHAR(32)) 
            + cast(de.EntityCode AS VARCHAR(32)) 
            + isnull(cast(de.DelegationCode AS VARCHAR(32)), '') as 'RowID' ,
            *
from    workflow.delegation_engine de
where   RowID <> NULL

When I try to execute the following I receive the error:

Msg 207, Level 16, State 1, Line 13 Invalid column name 'RowID'.

Just wondering how I can reference this temporary column? I searched for previous postings which suggested using 'having' for this however that doesn't appear to work either.


Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!