Thanks guys!

I didn't think this was possible...if I find anything out, I'll post it somewhere.

I am having the same error over here, win2k3 box w/ upgrade from ms sql 2000 to sql 2005. I then installed SP1 and it is still happening. Anyone have...

Greasham...good call on the ASP thing; that's what I usually write in. I did figure out what to do in that case (and yes, lxz20, it is MX). There is...

i got what i needed...cept i had to select a value from a temp table into a cursor that did a "fetch next into" my variable.

yeah, that works, but i need to return the value or set it to a variable

thanks pete...that's what worked (full four part reference of the table)

do something like this:

declare @employeephone char(255), @varvalue varchar(1000)

set @employeephone = '1234567890'

if @EmployeePhone is not null

begin

 set @varvalue = '<EmployeePhone>' + @EmployeePhone + '</EmployeePhone>'

end