Gossamer Forum
Home : General : Chit Chat :

SQL Query Help - Formatting the display

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

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
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.