sql - Updating tables in Sage -

i'm getting error doing simple update function.

begin transaction update dbo.slcustomeraccount set syscreditbureauid = 'the id number' (customeraccountnumber 'a%') rollback transaction 

this works fine when stating 1 account add comes message stating string or binary data truncated procedure.