Re: Add text at beggining of each row of output

Hey Jim,

     That is exactly how you would do it. If you would like the test to appear in its own column it would be:

     SELECT 'Static Text', column_a, column_b
     FROM...

     ...and if you want the test to appear with an existing column:

     SELECT 'Static Text: ' || column_a, column_b
     FROM...

Jay!!!

jimbob4334_at_my-deja.com wrote:

> How would I put text at the beginning of
> each line of output from an sql query.
>
> For example
>
> select
> 'text',b,c
> from db
>
> TIA,
>
> Jim
Received on Wed Sep 22 1999 - 12:21:20 CDT