Gossamer Forum
(Advanced Search)
for
Home : General : Chit Chat :

SQL Query Help - Formatting the display

Jun 15, 2003, 8:45 PM
GornHorse
New User (1 post)
Jun 15, 2003, 8:45 PM
Views: 4090
Shortcut
Quote Reply
SQL Query Help - Formatting the display
Hi,

Just wondering about how to do this...

I have the following current query in sql:

Select [FileFolderNo] as 'File Folder No', [Part No] as 'Part No', [TitleLevel1], [TitleLevel2], [TitleLevel3], [TitleLevel4] from Details where [FileFolderNo] = 'ACCQAC' and [PartNo] like '%1'


This works great. However, what i'm wanting to do is display [TitleLevel1], [TitleLevel2], [TitleLevel3], and [TitleLevel4] within the one column titled [Title].

And, if possible, display them as [TitleLevel1] <enter> [TitleLevel2] <enter> etc.

If displaying them line by line is not possible, that is not too big a drama; however, i really need to be able to display the titlelevels within the one column.

Thanks very much for that!

Regards,
Michelle Crazy
Subject Author Views Date
Thread SQL Query Help - Formatting the display GornHorse 4090 Jun 15, 2003, 8:45 PM
Thread Re: [GornHorse] SQL Query Help - Formatting the display 		perlman 3868 Jun 16, 2003, 5:07 AM
Post Re: [perlman] SQL Query Help - Formatting the display 		Paul 3840 Jun 16, 2003, 6:32 AM