>Cindy that may be part of it.However I can succesfully query a single row without a problem and the one row does have empty numeric values. they show up as 0.00 in fox but ?empty(inamount) = .t.
>
>Do you know how I can retrieve the record/row # that causes the exception?

Can you determine if it's just that one row or any row that's beyond the first? As was said before, can you narrow it down to which field is the problem? Do you have FoxPro so you can know what the actual data is in that row or that particular field?