Help! Trying To Create A Trigger In SQL 2000...

Hello All!

I am trying to create a trigger that upon insertion into my table an email will be sent to that that recipeinent with a image attached ( like a coupon)That comes from a different table, problem is, It will not allow me to send the email ( using xp_sendmail) with the coupon attached. I am using varbinary for the coupon and nvarchar for the rest to be sent, I get an error that Invaild operator for data type. operator equals add, type equals varchar.

Looks basically like this(This is my test tables):

CREATE TRIGGER EileenTest ON OrgCouponTestMain
FOR Insert
AS
declare @emailaddress varchar(50)
declare @body varchar(300)
declare @fname varchar(50)
declare @coupon varbinary(4000)

if update(emailaddress)
begin

Select
            @emailaddress=(select EmailAddress from OrgCouponTestMain as str),
            @fname=(select EmailAddress from OrgCouponTestMain as str)
            @Coupon=(select OrgCoupon1 from OrgCouponTest2 as image)

 

SET @body=  'Thank you' +' '+ @fname +' '+ ',Here is the coupon you requested' +'  ' + @coupon
exec master.dbo.xp_sendmail
            @recipients = @emailaddress,
            @subject = 'Coupon',
           @message = @body
END