Break it down to an if/else.
>is_pod is part of the string - I am using @ for long strings that span multiple lines.
>
>is_pod is a tinyint column in the table.
>
>UT syntax color parsing can not figure this out, but the AND layer part is the continuation of the string.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer