JSFiddle - React, Tailwind, and code Playground
by tsdexter
JavaScript
SELECT TOP 5 case when ckc_comment is null then lgh_endcty_nmstct else ckc_comment end as ckc_comment,
case when ckc_date is null then lgh_enddate_arrival else ckc_date end as ckc_date,
convert(bit,case when ckc_comment is null then 1 else 0 end) as fbolDisplayOneRecord
FROM checkcall RIGHT OUTER JOIN legheader
ON checkcall.ckc_lghnumber = legheader.lgh_number
WHERE legheader.ord_hdrnumber = #FORM.txtSearch#
ORDER BY ckc_date DESC