need to convert from ACCESS to TSQL

WHERE ( ((Mid([tblLabourFiles.CaseNum],6,2)) = [enter 2-digit year]) AND ((Left([tblLabourFiles.CaseNum],4))>= [Enter first 4-digit Case #] AND (Left([tblLabourFiles.CaseNum],4))<= [Enter last 4-digit Case #]) AND ((tblLabourFiles.Act) <> 'esc')) ORDER BY Mid([tblLabourFiles.CaseNum],6,2), Left([tblLabourFiles.CaseNum],4), tblEmployerName.EmpName Need to convert to T-SQL
 
Mathieu Alexandre Cupryk www.omegalove.com ...