ahh... I was connected to a SQL 2008R2 server. When I connected to a 2014 Server it works just fine!

Different syntax for 2008?

Thanks

Also, said multipart identifier could not be bound... the field CARD.ORDINAL

Placing the IIF first, don't get the multi-part identifier could not be bound error? It looks to be in the...

SELECT

CARD.PARENTACCOUNT AS ACCOUNT,

CARD.NUMBER AS CARD,

CARD.ORDINAL,

CARD.STATUS,

NAME.FIRST AS OWNER,

...

Thanks! I got an error saying the function requires 3 arguments?

Thanks!