Right Justified with leading zeroes

benchpolo

ColumnName: issueamount (No Decimal Places)
Columnlength: 10
Data: 9999

How can I export the data of 9999 to a fixed length text (.txt) file with a leading zero infront like 0000009999?

left(IsNull(ltrim(rtrim( issueamount)),'')+ ' ',10)

Thanks.

ck9663

Modify your code to:

right(IsNull(ltrim(rtrim(cast(issueamount as varchar(5)))),'')+ '0',10)

-- CK

deepuv04

Hi,
Try the following code

[code =sql]
SELECT REPLICATE('0', 10 - LEN(CAST(issueamount AS VARCHAR(10)))) + CAST(issueamount AS VARCHAR(10))

[/code]

Thanks

Right Justified with leading zeroes

re: Right Justified with leading zeroes

re: Right Justified with leading zeroes

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about