select ownerId, fsltablecode, operatorId, fsl_choId, mfrCustNum from tbl_OPR_ClientOperators o with (nolock) where fsltablecode = 'MSC' and ownerId = 226 and oprCompanyType = '0' and fsl_choId > 0 and len( mfrCustNum ) = 6 order by fsl_choIdDate