Help adding text to column with sql 2005 query

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi there,
I'm quit newby to this, so i'd like to have some help please.

I've a column whit some text where i want to insert more text before
and after, with sql 2005.
I'm trying this way, without success:

.....
update dbo.log
SET dbo.log.text = ('lot1' + dbo.log.text + 'lot2')

What shall i do in order to have success?
Thanks in advance.

.