Re: SQL problem...

Jimmy,

Have you thought of using Dynamic SQL ? ... Then your SQL form code could create the appropriate SQL select statement and and then execute it. Rather than concatenate the output of each select, why not use the UNION operator ?

i.e.
select a,b,c from t where a = 'string1'
union
select a,b,c from t where a = 'string2'
union
select a,b,c from t where a = 'string3'
...
/

Cliff Received on Sat Aug 22 1998 - 00:00:00 CEST