> I've created a UDF now and it seems to be working OK.

> I was just wanting to check that I actually needed to <g>

I use UDFs for this sort of thing - it makes life much easier to build
the necessary SQL statements etc. There are long hand ways of working
out if a "bit" is set without actual bit manipulation, but they can be
hard work to write. :-)

--
Geoff Worboys - TeamIBO
Telesis Computing