I hope this helps somebody. I decided to use this code:

-- Make temp table and loop through for test.

CREATE TABLE #TEMP_FullName

(

ID int IDENTITY(1,1) ,

FullName varchar(100) )

--...

Thanks All!!!

Final script below:

Tested and Works:

UPDATE [Contract]

SET Remarks = REPLACE(CONVERT(VARCHAR(MAX), Remarks), '{@CR}', ' ')

WHERE Remarks LIKE '%{@CR}%' ]

Thanks again! YEAH NO CURSOR!!

Thanks All!!!

Final script below:

Tested and Works:

UPDATE [Contract]

SET Remarks = REPLACE(CONVERT(VARCHAR(MAX), Remarks), '{@CR}', ' ')

WHERE Remarks LIKE '%{@CR}%' [/color]

Thanks again! YEAH NO CURSOR!

All-

So is there a way to use this:

update #tmp

set Remarks = replace(convert(varchar(max), Remarks), '{@CR}', '!!!!!')

and then do something like this:

update #tmp

set Remarks =...

All,

I actually used the Replace function first but the Text field is much larger than 8000 CHARS so the VARCHAR(MAX) will cut off some of the Data in that field...

Sorry Glich in first posting!

Hello,

I have a Table in my DB that is used by multiple other tables. It looks like this:

ID Type User_ID

1 ...

I am actually using it like Derrick has it. It works for that checkbox no problem!

When I make normal changes to my Visit table (Table I am checking to see...

Thanks Derrick!

Thnank Barry!

That works but when I update any other column in that row still executes the email procedure which is fine because the @emailTo is null.

New problem. It won't...