[SyS]

Sorry i cant understand what you said can please explain it better? i think you are talking about selecting rows having job is not null. If thats the case you can use WHERE clause with NOT NULL or <>NULL statements.