OK, in SQL Management Studio, how do I set the vars? I have reached a brain cramp and can't believe I cannot think of it. it doesn't like this:

select * from agency
SET	lcstring = 'HIGH POINT'
SET lcnewstring = 'TRACY'
update agency set agencyname = REPLACE(agencyname,lcstring,lcnewstring)
select * from agency

or

select * from agency
DECLARE lcstring = 'HIGH POINT'
DECLARE lcnewstring = 'TRACY'
update agency set agencyname = REPLACE(agencyname,lcstring,lcnewstring)
select * from agency

>>

>>lcoldstring = 'old value'
>>lcnewstring = 'new value'
>>UPDATE vhstatus SET vhnote = STRTRAN(vhnote,lcoldstring,lcnewstring)
>>

>>
>>Any idea how to do that in SQLServer 2000 (Not vfp will be using sqlexec())?
>

>lcoldstring = 'old value'
>lcnewstring = 'new value'
>UPDATE vhstatus SET vhnote = REPLACE(vhnote,lcoldstring,lcnewstring)
>