SQL — Update Char13
Apr 29, 2021
SELECT
dbo.PRODUCT.[PRODUCT_ID],
dbo.PRODUCT.[OWNER_CODE],
dbo.PRODUCT.[P_ID],
dbo.PRODUCT.[P_NAME_TH],
dbo.PRODUCT.[P_BARCODE],
SUBSTRING(P_BARCODE,0,CHARINDEX(CHAR(13), P_BARCODE ,1)) as name,
REPLACE(P_BARCODE,char(13),’’)
FROM dbo.PRODUCT
WHERE dbo.PRODUCT.[OWNER_CODE] = ‘1577’
AND P_BARCODE like ‘%’+char(13)
