USE T22M001

UPDATE BILL_DETAIL SET VOUNO = BILLNO, TRANSLRCASE = CONVERT(VARCHAR(6),CONVERT(NUMERIC(6),LEFT(BILLNO,6))) + ' X 1'