user6565949 user6565949 - 1 year ago 98
SQL Question

IF ELSE in SQL Server

I have the following column in Microsoft SQL Server called

and I want to create another column called
Type 1
which would be 1 if account starts with letter A, 2 if account starts with D....

I am new with this so could someone please advise?

Type Type 1
AD 1
AV 1
AC 1
DE 2
DR 2
DG 2
KL 3
KL 3

Answer Source

Use CASE instead of IF:

        WHEN Type LIKE 'A%' then 1 
        WHEN Type Like 'D%' THEN 2 
        WHEN ...
    END AS Type1
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download