SELECT     ORDERS.INMATENO, ORDERS.LASTNAME + ', ' + ORDERS.FIRSTNAME AS FULLNAME, ORDERS.SID, ORDERS.DOB, ORDERS.ORDERTYP, ORDERS.URGENCY, 
                      ORDERS.CALLWHO + ', ' + CONVERT(char(10), ORDERS.CALLDATE, 1) + '@ ' + ORDERS.CALLTIME AS Called, ORDERS.LOGDAT, ORDERS.SAMPDATE, 
                      ORDERS.SAMPTIME, ORDERS.DONEDAT, ORDERS.CLIENTID, ORDERS.MD, ORDERS.UPDDATE, RESULTS.SERVGRP, RESULTS.SORTER, RESULTS.SINONYM, 
                      RESULTS.ANALYTE, RESULTS.CHRRES, RESULTS.CTEXT, RESULTS.TEXTSPEC, RESULTS.UNITS, ORDERS.SEXSHORT, dbo.IsOutOfRange(ORDERS.SEXSHORT, 
                      RESULTS.CTEXT, RESULTS.FMIN, RESULTS.FMAX, RESULTS.MMIN, RESULTS.MMAX, RESULTS.LOW, RESULTS.HIGH) AS OutOfRange, 
                      dbo.GetGenderLow(ORDERS.SEXSHORT, RESULTS.FMIN, RESULTS.MMIN) AS GenderLow, dbo.GetGenderHigh(ORDERS.SEXSHORT, RESULTS.FMAX, 
                      RESULTS.MMAX) AS GenderHigh, RESULTS.FMIN, RESULTS.FMAX, RESULTS.MMIN, RESULTS.MMAX, RESULTS.LOW, RESULTS.HIGH, RESULTS.COMMENT, 
                      ORDERS.NOTES1, CLIENTS.CLIENT, CLIENTS.ADRESS + ', ' + CLIENTS.CITY + ', ' + CLIENTS.STATE + ' ' + CLIENTS.ZIP AS ClientAddress, 
                      CLIENTS.CLIENT + ', ' + CLIENTS.ADRESS + ', ' + CLIENTS.CITY + ', ' + CLIENTS.STATE + ', ' + CLIENTS.ZIP AS FACILITY, 
                      CASE Orders.DoFast WHEN 'F' THEN 'Fasting' WHEN 'N' THEN 'Non-Fasting' WHEN 'U' THEN 'Unknown' ELSE '' END AS PatientStatus, 
                      CASE Results.Analyte WHEN 'HCVVL2' THEN 'Performance characteristics of this test have been established by the CMC Laboratory.  This test has not been cleared by the U.S. FDA. The FDA determined that such clearance or approval is not necessary.'
                       ELSE '' END AS Disclaimer
FROM         CLIENTS INNER JOIN
                      ORDERS INNER JOIN
                      ORDTASK INNER JOIN
                      RESULTS ON ORDTASK.ORDNO = RESULTS.ORDNO AND ORDTASK.TESTCODE = RESULTS.TESTCODE ON ORDERS.ORDNO = ORDTASK.ORDNO ON 
                      CLIENTS.CLIENTID = ORDERS.CLIENTID
WHERE     (ORDTASK.TESTNAM NOT LIKE 'MICROSCAN%') AND (RESULTS.SID = '100292759')
ORDER BY ORDTASK.SERVGRP, RESULTS.TESTNO, RESULTS.SORTER, RESULTS.SINONYM