output from query analyzer 1

[beechill4]

Hi,

i have the following code running in query analyser:
PRINT '2.1 DATABASE NAME'

SELECT PROPERTY_VALUE as 'Database Name' FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'GLOBAL_DB_NAME'

the output is as follows:
2.1 DATABASE NAME
Database Name
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORMT
FERMATT


how do i get rid of the '-------' part of the output?

 

[DrSql]

In your query analzer got Tools==>Results in Grid.
Also try
Rtrim(Ltrim(lTrim(Database Name)


Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[beechill4]

hi,

i am try to get the results to file, so to grid is of little use

tried the Rtrim(Ltrim(lTrim(Database Name)
and no change to the output

 

[Pattycake245]

There is a way to turn these off, however it will also not print out headings to your file.

Go to Tools--->Options
Click on the Results tab.
Uncheck the "Print Column Headers(*)" option

You wil get your results only without the headings.

Don't know if this helps you at all.

Tim

 

[beechill4]

hi,

thats a big help. should get me what i require.

Thanks!