(formatting removed..... sorry)
Another way would be to create a temp table .....
PROJECT TEMPORARY tablename FROM gl_pur_01 USING gl_acct WHERE gl_acct IN +
(SELECT gl_acct FROM gl_pur_01 WHERE gl_acct IS NOT NULL)
this way you will have all the values you want and only using one command.
GARY
At 09:36 AM 6/22/01 -0400, you wrote:
>G-Day all
>
>I started out this morning to do what I thought a simple thing. To build
>a sub-select statement that would return into a variable the values in a
>column that are not null and distinct even if it is in the column more
>than once..
>
>I want the variable to contain 6090,7010,4050,1320,1590 ... and so on...
>
>The data in the columns is text/12 and here is what I attempted so far.
>
>SELECT gl_acct INTO vg_gl_acct FROM gl_pur_01 WHERE gl_acct IN +
>(SELECT gl_acct FROM gl_pur_01 where gl_acct is not null and limit=1)
>
>Thanks
>Jim Limburg
