Jason,

Square brackets are string delimiters, just like double and single quotes...

Or perhaps that is what you are saying, but the name of the table is BanklineRds (from looking at the rest of the CASE statement), so that doesn't appear to be the problem.


>I noticed that you are using square brackets [] around the table name in the FOUND function. You don't have a #DEFINE'd constant with the same name as the table, as using [] will substitute the constant value.
>
>Regards
>
>Jason