>
>There must be a fix for your query, nothing I hate worse than hard-coding a
>fix that should be done at the query level. :(

Yeah, I agree - the whole point of having a DBMS is moving as much of your
SQL onto the server as possible, thus preserving your business rules.

However, I am making good progress in converting this POS into Firebird,
and moving the SQL client - side.

Thanks

Tim


[Non-text portions of this message have been removed]