SELECT DISTINCT 
 TOP (100) PERCENT PERSONID AS EmpID, CONVERT(numeric, PERSONNUM) AS ClockNo, FIRSTNM + ' ' + LASTNM AS EmpName, EMPLOYMENTSTATUS, 
HOMELABORLEVELNAME3
FROM         KronosWFC.dbo.VP_EMPLOYEE
WHERE     (EMPLOYMENTSTATUS = 'Active')
ORDER BY ClockNo

SELECT DISTINCT 
 TOP (100) PERCENT PERSONID AS EmpID, CONVERT(numeric, PERSONNUM) AS ClockNo, FIRSTNM + ' ' + LASTNM AS EmpName, EMPLOYMENTSTATUS, 
HOMELABORLEVELNAME3
FROM         KronosWFC.dbo.VP_EMPLOYEE
WHERE     (EMPLOYMENTSTATUS = 'Active') AND (CONVERT(numeric, PERSONNUM) = 722)
ORDER BY ClockNo

WHERE     (EMPLOYMENTSTATUS = 'Active') AND (CONVERT(numeric, PERSONNUM) = 722)

WHERE     (EMPLOYMENTSTATUS = 'Active') AND (PERSONNUM = CAST('722' AS DATATYPE))

SELECT DISTINCT
        PERSONID AS EmpID,
        CONVERT(NUMERIC, 722) AS ClockNo, -- we know the ClockNo is 722 per the WHERE-clause
        FIRSTNM + ' ' + LASTNM AS EmpName,
        EMPLOYMENTSTATUS,
        HOMELABORLEVELNAME3
FROM    KronosWFC.dbo.VP_EMPLOYEE
WHERE   EMPLOYMENTSTATUS = 'Active'
        AND PERSONNUM = CAST('722' AS NVARCHAR(15));