Topic awaiting preservation: varchar calculation problem(MS SQL Server ) (Page 1 of 1)

Hi, guys. How are ya?
I have realized one of data field showing wrong data.
I have been playing around stored procedure using MS SQL server.
The problem is that I cannot make string using two field combinmed together rihgt.
For example:
bankcode----- branch number
0001 ----------- 222

result:1222

Those two field data type is varchar. I expected to get 0001222 not like above at all.
If I want to preserve those 0 things, what shoule I do?
Please help me.

(Edited by Tekapo on 09-10-2004 04:35)

Hi, people. I solved it. cheers.
Thanks anyway.

Well, since you solved it would you care to post up here the language that you're using and how you solved it? That way anyone else who might have this question can actually find an answer to it

Thank you.