1jaws
asked on
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...
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER