>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

Did you set value for @iIpoId already?