TalkPHP - View Single Post

Wildhoney · 09-30-2007, 11:45 PM

Zerofill should have done it, but something like:

Code:

INSERT INTO
	myTable
	(myColumn1)
VALUES
	(LPAD(00650, 5, 0))

09-30-2007, 11:45 PM	#4 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	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.