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