Zerofill

sonia.sardana

New Member

Join Date: Jul 2006

Posts: 95
#1

Zerofill

Feb 17 '08, 07:12 PM

Hi frnds, I want to know that zerofill is a valid function in SQL or not....
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Feb 18 '08, 01:36 AM

I think that's a MySQL function. If that's a function that left-pad the value with '0', you can still re-create it in sql-server. Something like:

Code:

SELECT right('0000000000' + rtrim(ltrim(cast(@myInt as varchar(10))),10)

-- CK
Comment

Comment