>>2: RunSQL SQL Statement:
>>

UPDATE transaction SET particulars=changeover() WHERE LEN(particulars>0

>
>Doesn'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

Thank You!!!

Ric