Still need Informix Help!

My original question.... Has anyone seen the syntax with either a double pipe ("||") or a single pipe ("|") betewwn the two selected fields.. I've seen this before and used it before (or something like it) and do not recall the exact syntax. The original question I still cannot find a solution..... The original situation was: ---------------ORIGINAL QUESTION--------------------------------------- I remember there was a way starting with version 4.1 where you could do a select using the "in" and "not in" functionallity on multiple fields. For example table a x char(10) y smallint table b x char(10) y smallint You want to find all the rows in table a were there is an "x in table a and no coorresponding "x" in table b the query would be: select rowid from a where x not in (select x from b) Now the question - how do you find all the x and y combinations in table a where they are not in table b. I thought the syntax was something like: select rowid from a where x || y not in (select x || y from b) But I can't seem to make it work or find it in the manual... Anyone else seen this???? -------------END ORIGINAL QUESTION---------------------------- Has anyone else seen this in some liturature from Informix????? By the way - does anyone have a list of the "unpublished" Informix 4GL functions out there??? I know of: sin fgl_drawbox err_get mod anyone have any others????? Stuart Litel Internet: 75110.1120@compuserve.com