Thank you all of you.

They are very helpful. Especially this one: STUFF(REPLACE(STR('1416', 4), ' ', '0'), 3, 0, ':')

Hi, Dave

Thank you for reply with suggestion. I understood that the T-SQL statement cannot be used on Data Conversion editor as the editor has no option to take it. Like...