I have a VIEW that compares two fields from two tables in the same database, the trouble is that one field has leading zero's and the other doesnt, I cannot update the table containing the field with leading zero's as this will impact on other process that
have been wriiten to compensate for the leading zero's and would therefore like to write the update into the VIEW, so that the table data is not disturbed.
This is an excerpt from the code...
WHEN ledgertrans.paymreference='-%' AND ledgertrans.paymreference=vendtrans.voucher AND vendtrans.paymreference=bankchequetable.chequenum
View Complete Post