select p.portfolio,
       mt.text
from   [message] m
       join message_type mt
         on mt.id = m.message_type_id
       left join portfolio p
         on p.id = m.portfolio_id
       left join security s
         on s.id = m.security_id
       left join benchmark b
         on b.id = m.benchmark_id
       left join holding h
         on h.id = m.holding_id
       left join transactions t
         on t.id = m.transaction_id
where  mt.id = '2008' 

portfolio	text
9815T025020	Finished History Engine for portfolio ID %s. 

select p.portfolio,
       s.cusip,
       cast(getdate() as SMALLDATETIME),
       mt.text
from   [message] m
       join message_type mt
         on mt.id = m.message_type_id
       left join portfolio p
         on p.id = m.portfolio_id
       left join security s
         on s.id = m.security_id
       left join benchmark b
         on b.id = m.benchmark_id
       left join holding h
         on h.id = m.holding_id
       left join transactions t
         on t.id = m.transaction_id
where  mt.id = '2024' 

portfolio	cusip	(No column name)	text
9861E084027	USD	2010-08-30 	Portfolio ID: %s History Rule: 5160 - Principal Value of holding is zero for Security ID %s on %s. 

quote:

---

Originally posted by tkizer

You should not be doing this in T-SQL as this is a presentation issue. Return the raw data back to the application and do the formatting there.

If you must do this in T-SQL, which seems highly unlikely, then use the REPLACE function.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

---