Will the real Sub-Select please stand up

[Jim Limburg]

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