Convert NDC numbers In SQL

I need some to write me the SQL (in phpmyadmin) to convert the NDCPackageCode database found here: ([login to view URL]) into CMS format. The CMS pads the package code segments of the NDC with leading zeroes wherever they are needed to result in a fixed length 5-4-2 configuration (but always written without dashes). AKA I need to zero fill each segment for a 5-4-2 format and remove the dashes. Kinda Simple Im stumped though.