Option one: RIGHT ( ("0000000000000000" + @[User::TERMINALID] ), 16)

OR

RIGHT ( (REPLICATE("0",16) + @[User::TERMINALID] ), 16)

Assuming that the TERMINALID is a variable, if not and it is a column name, Use just RIGHT ( ("0000000000000000" + TERMINALID ), 16)

Point to note, expressions are case sensitive for column or variable names.

Hi Sundeep, its not working and my data having spaces Input: 12345spacespacespacespace...... expected Output:0000000000012345

If you have spaces use LTRIM(RTRIM(TERMINALID)) in place of the variable or column name. Also what is the error that you are getting.

You need to give more detail... is it a column or a variable... what is the error, any other information..

thanks lot sandeep, i got answer using LTRIM &RTRIM