I was provided with a SQL Trigger yesterday by one of your members which works.
I have since discovered the program which inserts the data has a bug whereby it's creating a carriage return and a space before the data.
I was wondering if l can include in the below trigger script a workaround, whereby it removes the left space and carriage return first before the update?
The data type is TEXT. I'm not sure why the developer of the database is using TEXT.
CREATE TRIGGER TRANSHEADERS_CustomerRef_Update
FOR INSERT AS
Set ZCustomerRef = ExtraText
Where AccountID = 'CAWWWEBXXXX'