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
Post #1 of 3
Views: 3328
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
Jun 16, 2003, 5:07 AM
perlman
User (150 posts)
Jun 16, 2003, 5:07 AM
Post #2 of 3
Views: 3139
Shortcut
Quote Reply
Re: [GornHorse] SQL Query Help - Formatting the display In reply to
Think you've posted this thread in the wrong category! Wink

- perlman
Jun 16, 2003, 6:32 AM
Paul
Veteran (19537 posts)
Jun 16, 2003, 6:32 AM
Post #3 of 3
Views: 3120
Shortcut
Quote Reply
Re: [perlman] SQL Query Help - Formatting the display In reply to
I moved it here. It was posted in the links sql forum and I was trying to pick a suitable forum to move it to and unless I mis-read the post it just seems to be to do with formatting text.