================================================== =======
CASE
WHEN so.PhoneNum LIKE '999%' THEN 'Chester'
END AS Company,(Works!)
================================================== =====
But how can I get it to work checking more than 1 instance of PhoneNum?
This doesn't work:
================================================== ====
CASE
WHEN so.PhoneNum LIKE '999%' THEN 'City1'
WHEN so.PhoneNum LIKE '997%' THEN 'City2 '
WHEN so.PhoneNum LIKE '998%' THEN 'City3'
END AS Company,(Fails!)
================================================== ====
This fails with an out put of "NULL"
ThanksFound the solution - this works!
[Company] =
CASE
WHEN so.PhoneNum LIKE '999%' THEN 'Chester'
WHEN so.PhoneNum LIKE '998%' THEN 'Camden'
WHEN so.PhoneNum LIKE '997%' THEN 'Great Falls'
WHEN so.PhoneNum LIKE '803%' THEN 'Winnsboro'
END,
No comments:
Post a Comment