Nov 1, 2007

Update DB Data With Leading Zero Format

UPDATE EM_MST_EMPLOYEE
SET PIN = '0' + PIN
WHERE ({ fn LENGTH(PIN) } = 7)

No comments:

Post a Comment