Zeros in query?
View Single Post
09-30-2007, 11:45 PM
La Vida es Sueño
Join Date: Sep 2007
Zerofill should have done it, but something like:
INSERT INTO myTable (myColumn1) VALUES (LPAD(00650, 5, 0))
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.
View Public Profile
Send a private message to Wildhoney
Visit Wildhoney's homepage!
Find More Posts by Wildhoney