UPDATE transaction SET particulars=changeover() WHERE LEN(particulars>0Doesn't changeover requires a parameter? And a parentheses is missing. The Complete query should read:
UPDATE transaction SET particulars=changeover(particulars) WHERE LEN(particulars) >0