----UPDATE THE LAST COUMN BY USING FOLLOWING STATEMENT----
Update INVOICE_HEADERS_STG90
set VENDOR_SITE_CODE = replace (VENDOR_SITE_CODE, CHR (13))
where VENDOR_SITE_CODE like '%' || CHR (13) || '%';
Update INVOICE_HEADERS_STG90
set VENDOR_SITE_CODE = replace (VENDOR_SITE_CODE, CHR (13))
where VENDOR_SITE_CODE like '%' || CHR (13) || '%';
No comments:
Post a Comment