add where t0.u_iis_dddt is >= 1.1.09

my mind has gone completely blank! How do i add >= to 1.1.09?

Thanks

K

SELECT  T0.[U_IIS_DDDT],  T0.[U_iis_plan], t0.U_AVL_offered, dbo.fhGetWorkingDaysWithoutWeekEnds(T0.createdate, T0.[closeDate])                     AS DaysToClose, t0.u_avl_na1,T0.U_AVL_na2, T0.U_IIS_INSCODES, T0.subject, T0.U_IIS_INADR, T0.custmrName FROM [dbo].[OSCL]  T0 LEFT OUTER JOIN [dbo].[OHEM]  T1 ON T0.technician = T1.empID INNER JOIN OCRD T2 ON T0.U_iis_job = T2.CardCode INNER JOIN OUSR T3 ON T0.assignee = T3.INTERNAL_K INNER JOIN OSCS T4 ON T0.status = T4.statusID WHERE LEFT(t2.ZipCode, 2) IN ('BH','OX','RG','sl','so','sp') order by t0.U_IIS_DDDT, T0.U_IIS_PLAN, T3.U_NAME, T2.ZipCode

Select allOpen in new window