Xp_sendmail Http Question

The @IMGRPNAME, if it is two words, the second word is not a weblink. ANy idea? @IMGRPNAME is declare as varchar(1000)





****************************





Set @IMGRPNAME = (select IMGrpname from IM where IMID = @IMID2)


Set @IMEmail = (select IMEmail from IM where IMID = @IMID2)


Set @IMID3 = (select IMID from IM where IMID = @IMID2)


SET @MsgText = ' has been without a last resort implementer for the past 24 hours. Please click here to assign a last resort implementer: http://ssx_emps.aspx?imid=' + @IMID3 + '&imgrpname=' + @IMGrpName


SET @FullText = @IMGRPName + @MsgText


EXEC master.dbo.xp_sendmail


@recipients = @IMEmail,


@Message = @FullText,


@Subject = 'SAMS Implementation Group needs attention'