existing components in piping database

is there a simple way to filter out components in piping database marked existing in model?

It should be putting everything on the existing layer

Existing/new is bit-coded into one of the fields, along with fabrication/erection/module/offshore and a couple of others. You'll need to do a bit of work to dig it out e.g. bitwise AND with the appropriate mask, or convert to binary and check the digit value.

thanks

the query to run is

SELECT PIPE.DWG_NAME, PIPE.ALPHA_SIZE, PIPE.LINE_NUM, PIPE.LONG_DESC, ([PIPE]![FLAG]\(4)) Mod 2 AS STATUS
FROM PIPE
WHERE (((([PIPE]![FLAG]\(4)) Mod 2)=0));