wat is the sql query used to replace two or more records in a column

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

For example i have a column named as gender and records are male and female.
so i want to replace male as M and female as F.
Please help me out

Posted 28-Apr-14 21:53pm

Member 10782522

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Devendra Singh shekhawat · Answer 1 · 2014-04-28T22:26:00

Solution 1

SQL

declare @temp table(gender nvarchar(50) null)
insert into @temp (gender)
select 'Male'
union all
select 'FeMale'
union all
select 'FeMale'
union all
select 'Male'
union all
select 'FeMale'

select * from @temp

update @temp set gender=(case (gender) when 'Male' then 'M' else 'F' end) from @temp

select * from @temp

Posted 28-Apr-14 22:26pm

Devendra Singh shekhawat

Comments

Hitesh Varde 29-Apr-14 5:02am

you not need to take 'from @temp' at the end in your query.

Devendra Singh shekhawat 29-Apr-14 5:38am

it's just a example

Hitesh Varde 29-Apr-14 5:53am

I just pointed if you want to update.

Hitesh Varde · Answer 2 · 2014-04-28T22:40:00

Solution 2

Hello,

Please try below query, Let me know if it helps.

SQL

UPDATE [YourTableName] SET GENDER=(CASE WHEN GENDER = 'Male' THEN 'M' ELSE 'F' END)

Thanks,
Hitesh Varde

Posted 28-Apr-14 22:40pm

Hitesh Varde