Re: A Tab in a Select statement

GZ <gz_at_yahoo.com> wrote in news:3C898A90.BBC524D3_at_yahoo.com:

> Is it possible to simulate a TAB in a select query in order to TAB
> delimit data?
>
> I had been previously using a comma to delimit data but ran into trouble
> when data started to include commas.
>
> example to comma delimit - select first_name||,||last_name||,||address
> from ......
>
> Any help would be much appreciated,

Use the CHR function. This function takes a position in the ascii character set and returns the character. I believe the hex representation for a TAB character is 09 so it would be:

select first_name||chr(9)||last_name||chr(9)||address from ...

-- 
Ken Denny
http://www.kendenny.com/

If at first you don't succeed - try management.