Hi Marco,

Thanks for the super fast reply.

It seems that multiplying the field by 1 in the where clause does the trick.
In the given example test1 changes to integer again:

SELECT test1, test2, COUNT(*) As Quantity
FROM Testtable
WHERE test1*1 = 1
GROUP BY test1, test2

i will try to do the automated search you suggested.