what data type are postofficefl and template?




>can you help me with this syntax
>
>

>update PostofficeFL set body = ( select template from TemplateFL with (nolock) where templateflid = 2 ) where Postofficeflid = @id
>

>
>I'm getting this error:
>

>Server: Msg 279, Level 16, State 3, Line 10
>The text, ntext, and image data types are invalid in this subquery or aggregate expression.
>
>