How to check for the value before you select it

[goal2007]

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

[ck9663]

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

try something like:

select case when name = 'MIKE' then 'CHRIS' when name = 'AJ' then 'SARAH'
as name, address from dbo.Customer

the problem with this is you will have a record with name = 'CHRIS' having Mike's Address. is this what you're trying to do?

[debasisdas]

As you have posted a question in the articles section it is being moved to SQL Server Forum.


MODERATOR.

[goal2007]

try something like:

select case when name = 'MIKE' then 'CHRIS' when name = 'AJ' then 'SARAH'
as name, address from dbo.Customer

the problem with this is you will have a record with name = 'CHRIS' having Mike's Address. is this what you're trying to do?

Thank you for your help, Now i am trying to do something like that



select FName(also i need to select the address)

if (SUBSTRING(FName, 1, 4)='Rani')

BEGIN

Replace(FName,'Rani','PO_Rani')


END

if (SUBSTRING(FName, 1, 3)='Cha')

BEGIN

Replace(FName,'Cha','PO_Rani')


END


from test1Users

thie is the error i get
Incorrect syntax near 'Replace'.


I tried to use the Case Statement but it did not work too



Thank you for your help

[rob313]

There was a synax error in the case statement. Try this

SELECT
CASE
when name = 'MIKE' then 'CHRIS'
when name = 'AJ' then 'SARAH'
else name
END as name
,address
FROM dbo.Customer