Hi All,

I am designing a stored procedure that will send an email to all receipients
in a queue. I decided to replace the following line in order to lookup and set the subject of the email dynamically:

set @subject = 'IPO # ' + ltrim(rtrim(str(@iIpoId))) + ' Notification'

to:

set @subject = (select cEmailSubject from webforms.dbo.lookup_emailTemplate where iEmailTemplateID = @iEmailTemplateID)

where the cEmailSubject field is:
'IPO # ' + ltrim(rtrim(str(@iIpoId))) + ' Notification'

In a result the email title is:
'IPO # ' + ltrim(rtrim(str(@iIpoId))) + ' Notification'

How can I get it to evaluate and display something like :

IPO # 1234 Notification

Thank you,
Daniel