Re: delimiters

In message <9204161741.AA22901@pd2>, Kristen Altman asks: ->I need to be able to put a delimiter between the data fields returned from ->a select statement. This data is being written to standard output. An ->example would be: ->isql testdb - ->select field1, field2, field3 from test; {where the delimiter is "|"} ->a |b |c | ->d |e |f | ->My application uses only Informix-ISQL. ->If anyone has any idea how this might be accomplished (without using the ->unload command), I would love to hear from you!! ->Thanks in advance ->Kristen Altman A simple way to do this in ISQL is to include constants in the SELECT statement: select field1, "|", field2, "|", field3, "|" from test;________________________________________________________________________________ Todd Glidden "Pat Who? In '92" Sacramento Army Depot Pat Paulson's Presidential campaign slogan ________________________________________________________________________________