| Record | SQL Expression | SQL Type |
| D1 | FROM RD1 LEFT OUTER JOIN
(SELECT tblCodeID, Code
FROM RECO.dbo.tblCode
WHERE (tblCodeTypeID = 1647)) AS C ON replace(replace(RD1.MetierL6,'Bigger','>'),'Smaller','<') = C.Code
WHERE (C.tblCodeID IS NULL) and RD1.MetierL6 is not null | Free SQL |