Re: delimiters
>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
> ...
Try this
select field1, "|", field2, "|", field3, "|" from test;
I hope this helps
MM
-------------------------------------------------------------------------------
| Manuel Figueiredo Monteiro |
| S.S.F. - Servicos de Software Financeiro, Lda VOICE: +351 (1) 727-0303 |
| Estrada da Luz, No 104 - Loja A FAX: +351 (1) 727-0335 |
| 1600 Lisboa E-MAIL: mm@ssf.pt |
| PORTUGAL |
-------------------------------------------------------------------------------