Search code examples
t-sqlsap-aseisql

Sybase TSQL how to select without `-` chars


My question is very simple, I am trying to print a combination of text and numbers, by using the SELECT statement. However, when I try to print text using this method, I get a lot of miscellaneous - chars.

How can I use the select statement without having it print the - chars?

For example:

SELECT "HELLO WORLD"

Would result in:

---------------------
HELLO WORLD

Solution

  • When lauching isql use the -b option to suppress header printing.

    isql -Uusername -Sservername -b