Padding

[msalvador]

I've to pad a string

my table is

PLU( barcode varchar(50),description(50))

and contains:

barcode |description
----------------------
000123456|Potatoes
002222222|Milk
222222222|Coke

i've to do the padding for the barcode

Select barcode,description from PLU

the resultset must be

barcode |description
----------------------
123456 |Potatoes
2222222 |Milk
222222222|Coke

anyone known if there are a function or a stored procedure

 

[jhall156]

One result is right justified left zero filled. The other is left justified right space filled. If that's what you want then try this:

SELECT SUBSTRING(barcode,PATINDEX('%[^0]%',barcode),<whatever the width of barcode is>) AS barcode, description
FROM <YourTable> JHall

 

[msalvador]

thanks

 

[msalvador]

wonderful it's work very well