Appending 2 Digits Infront Of A Column

I have a simple select statement. What I need is to append a 2 digit number infront of the relationship_type_id.


select distinct



customer_id,
acct_id,

parent_flag,

relationship_type_id

from customer_account sca


inner join account act


on sca.acct_id = act.account_number








the logic is that

If primary flag = 0 then 1st two digit of relationship_type_id = 10
else 1st two digit of relationship_type_id = 00

For Example:

Primary Flag Relationship_type_id After appending





Relationship_type_id


1 5 005
1 3 003
0 3 10
1 5 005
0 3 103



Can anyone help me with that?

Thanks