Problem with converting Data from Text to Numeric or Date in SQL

I have a csv file that is not formatted exactly the same every time.  So... in order to get the csv file into sql, I made a table with all Text columns and then import the file. My issue is that I have several fields that are dates, and since they are in SQL as text and not as Dates I can not run a query that involves dates.

How can I convert these on the fly for comparison.

Here is some sample data and my sql query at the bottom...
Thanks

125635/  JL/JL      963499709701      0034.61      34.0      1      11/03/2009      11/02/2009      4576
125719  DA/DA      963499710267      0026.51      22.0      1      11/04/2009      11/03/2009      4632
125809 JL/JL      963499710820      0011.25      05.0      1      11/05/2009      11/04/2009      4688
125729 DA/DA      963499710278      0028.52      22.0      1      11/04/2009      11/03/2009      4633
125775/  JL/JL      963499710289      0018.72      10.0      1      11/04/2009      11/03/2009      4634
125742/  DA/DA      963499710290      0027.38      22.0      1      11/04/2009      11/03/2009      4635
124328/C/DA      963499710304      0010.69      14.0      1      11/06/2009      11/03/2009      4636


select
ref as 'Reference',
case when patindex('%[0-9][0-9][0-9][0-9][0-9][0-9]%', ref) <> 0
      then cast(substring(ref, patindex('%[0-9][0-9][0-9][0-9][0-9][0-9]%', ref), 6) as int)
      else 0 end as 'SalesOrder #',
case when patindex('%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%', tracking) <> 0
      then cast(substring(tracking, patindex('%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%', tracking), 12) as bigint)
      else cast(substring(totalcustomercharge, patindex('%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%', totalcustomercharge), 12) as bigint) end as 'Tracking #',
shipmentdate
from fedex
where shipmentdate = '11/02/2009'