sql snytax

case
                  when datePaid is not null then 'Paid'
                  else 'Not Paid'
            end as status    

I want to bring saying if my hold column shows true .. that time I want to say Hold between Paid and not paid... how would do that .. cant get the snytax correct...
1jawsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
JestersGrindConnect With a Mentor Commented:
CASE WHEN DatePaid IS NOT NULL THEN 'Paid'
          WHEN HoldColumn = 1 THEN 'Hold'
          ELSE 'Not Paid'
END AS Status

Is that what you are looking for?

Greg

0
 
1jawsAuthor Commented:
thank you!!
0
All Courses

From novice to tech pro — start learning today.