Thread: Zeros in query?
View Single Post
Old 09-30-2007, 11:45 PM   #4 (permalink)
Wildhoney
La Vida es Sueño
Advanced Programmer Top Contributor 
 
Wildhoney's Avatar
 
Join Date: Sep 2007
Location: Oldham
Posts: 2,280
Thanks: 90
Wildhoney is on a distinguished road
Default

Zerofill should have done it, but something like:

Code:
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.
Send a message via AIM to Wildhoney Send a message via MSN to Wildhoney Send a message via Yahoo to Wildhoney
Wildhoney is offline  
Reply With Quote