Ask help for sql server

update tbl_surveys
set site_specific_3=(select site_specific_3 from youthmapentry.dbo.tbl_surveys
where site_number=youthmapentry.dbo.tbl_surveys.site_number
and [id]=youthmapentry.dbo.tbl_surveys.[id])

then I got this error
Server: Msg 279, Level 16, State 3, Line 1
The text, ntext, and image data types are invalid in this subquery or aggregate expression.

How can I do this update,

Thanks a lot

所有跟帖： 

• Use VARCHAR instead of TEXT -CutOnce- ♀ (12 bytes) () 09/03/2004 postreply 07:17:02

• 回複：Use VARCHAR instead of TEXT -peterqpang- ♀ (60 bytes) () 09/03/2004 postreply 07:53:22

• I found answer -peterqpang- ♀ (201 bytes) () 09/03/2004 postreply 08:20:11