SELECT *
FROM BPS_Patients
WHERE StatusText = 'Active'
AND RecordNo LIKE '%RACF%' -- Wrap the search/RACF prefix/suffix with % sign wildcards
ORDER BY SURNAME,FIRSTNAME

-- Search for patients if they have a record number recorded (where record number is used to record Aged Care Facility mapping)