From: "Clay Shannon" <cshannon@...>

>
> Are you sure all of the data is "small enough" to fit within the column
> sizes?
>

If everything fits using the simple query:

select * from InventoryList(20)

and everything fits using

select * from InventoryList(22)

then it serves to reason that everything should fit using

select * from InventoryList(20)
union
select * from InventoryList(22)


If the corruption caused a size problem, it should also be apparent in the
single query and not just when you UNION the two. Also, placing certain
criteria in the single query produces the error while certain other criteria
does not. It leads me to believe there is some corruption somewhere but I
just can't find it or fix it.

Woody (TMW)