Michel,

I was wondering if you had a table in the current work area, that had a column name the same as one of your where clause items that wasn't aliased in the select.. but the code sample you posted didn't so I dismissed that possibility. I should have gone ahead and asked anyway, it might have gotten you to the solution a little faster.

>Unpredictable results will occur if you insert a WHERE clause having an alias which is not used in the SQL. As soon as I discovered it and replaced it with the proper alias, all started to work as expected.