Help adding text to column with sql 2005 query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

astra14i@hotmail.com - 30 Jul 2007 23:25 GMT

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.

Reply to this Message

Daniel Crichton - 31 Jul 2007 08:22 GMT

astra14i@hotmail.com wrote on Mon, 30 Jul 2007 15:25:38 -0700:

> Hi there,
> I'm quit newby to this, so i'd like to have some help please.
[quoted text clipped - 9 lines]
> What shall i do in order to have success?
> Thanks in advance.

Maybe it's because text is a reserved keyword, as is log. Try this:

UPDATE dbo.[log]
SET [text] = 'lot1' + [text] + 'lot2'

If it gives the same result then how about posting some DDL. If [text] is a
text column, try changing it to a varchar(max) - a text column will probably
need to use the UPDATETEXT statement, but it's been a long time since I've
used it.

Dan

Reply to this Message