leading zero's not working .?

[ashmitp869]

Hi ,

What is wrong in my script with the leading zero's

Qlikview script :

MRN Pool HERO ID]&' '& right('0000000000'+[Client Facility Medical Record Number],10) as [MRN Pool HERO Id MRN]

But the end result is not showing zero's 

Please suggest ?

[ashmitp869]

I check the db , its varchar

How to add 000 before in varchar in Qlikview script ?

[marcus_sommer]

Try it with:

right('0000000000' & [Client Facility Medical Record Number],10)

or maybe:

num([Client Facility Medical Record Number], '0000000000')

- Marcus