Re: delimiters
In article <8743@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes:
>X-Informix-List-ID: <list.1071>
>Informix fans,
>
>I am having a major problem with my application and I'm hoping that someone
>can help.
>
>I need to be able to put a delimiter between the data fields returned from
>a select statement.
>
>>isql testdb -
>>select field1, field2, field3 from test; {where the delimiter is "|"}>
SELECT col1,"|",col2,"|" etc will do what you want
To my knowledge the delimiter specification only affects the unload
statement.
Don "reformed Oracle hacker" Bolton