How To Check For The Value Before You Select It

This is what i am trying to do:



Table dbo.Customers



Name: Address

Charlie 12344

Mik 12254

Steven 12545

AJ 12456



in my stored procedure: I want to select the column name and the address so I will have

select name, address from



* the question is how can I check if the name is Mike i want to replace it with Chris

so i am trying to do something like that

select if(name)='Mike' then i want to replace it with Chris, also if the name is =€™AJ€™ I want to replace it with €˜Sarah€™,

address from Customers



how can I check the value before I select it in my stored procedure

Thank you