Ethan Liew Technology Blog
Technology, Art, Solution, Tips, Multimedia, How To, What Is, Programming, Software, Freelance
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment