One Line Space Between Text - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

One Line Space Between Text

Author

Topic

swathigardas
Posting Yak Master

149 Posts

Posted - 2008-11-18 : 01:44:49

select isnull('Employee Notes: '+ e.notes_TXT,' ')+ isnull(' Employee SKill Notes: '+s.Notes_TXT,' ')
FROM TEmployee_Info e
Inner join TEmployee_Skills s
on e.Employee_NBR=s.Employee_NBR

I have a Query like this Which DisplaysNotes From two Tables. But the Requiremnt is that each and every note should be displayed
in the next line of the same record.. Now it is displaying like this
Employee Notes: For checking mail component Employee SKill Notes: Leading

But the requiremnet is Employee Skill Notes should appear in the next line.

Is it possible..

Thanks Before Hand
Swathi

John Sourcer
Yak Posting Veteran

91 Posts

Posted - 2008-11-18 : 01:48:48

You could of course include a :line break character at the beginning of each line.

swathigardas
Posting Yak Master

149 Posts

Posted - 2008-11-18 : 01:56:36

Thanks For the suggestion..
But I dont know how to insert the line separator code

Can u insert it in the above code and post it

John Sourcer
Yak Posting Veteran

91 Posts

Posted - 2008-11-18 : 02:08:45

Well that depends what your outputting too:

HTML: select isnull('Employee Notes: '+ e.notes_TXT,'')+ isnull('<br />Employee SKill Notes: '+s.Notes_TXT,'')

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-18 : 03:17:46

Isnt this a presentataion issue which is best dealt at your front end application?

swathigardas
Posting Yak Master

149 Posts

Posted - 2008-11-18 : 05:52:42

yeah as Jhon said. I've inserted <br> tag which displays data perfectly in the application

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources