PL/SQL CASE Statement

I keep getting errors on this.  Can someone help me write this statement correctly?  
Basically, if my first result ends in "0", then I want the first letter of the last name, else I want the last number of the Subscriber ID.


CASE substr(O221762."Subscriber_ID",9,1)
     WHEN "0" THEN  substr(O221762."Mbr_Last_Name",1,1) AS "CM_ID"
     ELSE substr(O221762."Subscriber_ID",9,1) AS "CM_ID"
END

Open in new window

Luis5011Asked:
Who is Participating?
 
Luis5011Connect With a Mentor Author Commented:
I figured it out.  I used the following format and added the " " around the field name, which I hadn't done.

CASE
     WHEN substr(O221762."Subscriber_ID",9,1)= 0 THEN  substr(O221762."Mbr_Last_Name",1,1)
     WHEN substr(O221762."Subscriber_ID",9,1)<>0 THEN  substr(O221762."Subscriber_ID",9,1)
END  AS "CM_ID",
0
 
ajexpertCommented:
How abt this?

 CASE substr(O221762.Subscriber_ID,9,1)
     WHEN '0' THEN  substr(O221762.Mbr_Last_Name,1,1) AS "CM_ID"
     ELSE substr(O221762.Subscriber_ID,9,1) AS "CM_ID"
END
 

Open in new window

0
 
Luis5011Author Commented:
Nope.  Tells me I have a missing key word.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.