Adding static text to output file

• Stephanus-466433

  SSC-Addicted

  Points: 427

  More actions

  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

• Stephanus-466433

  SSC-Addicted

  Points: 427

  More actions

  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