Re: Selecting data between markers via SQL.

[rob@xxxxxxxxx]

I reread it.  I think it's going to be awfully tricky in SQL.
INSERT INTO QTEMP/MIKE VALUES('go &field& go')
INSERT INTO QTEMP/MIKE VALUES('go &a&, go &b&')


with t1 as( 
select testchar, 
locate('&',testchar) as start, 
locate('&',testchar,locate('&',testchar)+1) as end
from qtemp/mike 
where posstr(testchar,'&')<>0) 
select testchar, 
substr(testchar,start+1,end-start-1) as field 
from t1 

 ....+....1....+....2....+....3..
 TESTCHAR         FIELD 
 t&st             +++++++++++++++
 go &field& go    field 
go &a&, go &b&   a 
 ********  End of data  ******** 

and if you're not using a variable length text field but instead are 
subfiling a bunch of 'line' rows you could have trouble with variables 
that span rows like:
Listen &CNNAME&.  You're a freaking deadbeat and you owe us %do
llars%.  If you don't pay up by &DateDue& then big Louie is per
sonally going to rip off your %anatomy%.

Rob Berendt