Post reply

Adding static text to output file

  • July 24, 2007 at 1:46 pm

    #69366

    Hi all,

      With a lot of help my query is working, now I am wondering if there is a way to insert static text into my output file at the time I run the query.

    for example, a lot of data is going to be repeated on each line of my output file that never changes like the the company name and address. I want to insert these at the time I run the query so it will be shown at each line of my text output file.

    I hope this make sense... if not I will try and explain it a little better.

    Thanks

    Stephanus

  • July 24, 2007 at 2:44 pm

    #722065

    Ok got it, I just added the text to the select statement,

    select tbl.name, 'static text'

     

    I works for my apllication.

    Cheers

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply