Converting Text - SQL

[Baz]

Another day, another problem...

If I have a text column in a table, where all the text is in the format '13.3.2007' how can I convert each row in it to a smalldatetime field?


Thanks

 

[Baz]

Using SQL 2000

What it is, is I am importing a load of text files into a temporary table, then from there moving it to a static table, on the way through I have put in amongst the Insert-Select statement 'CAST (Field_name AS SMALLDATETIME)' and see if it works.....

 

[Baz]

And it works....


This place has a aura about it, like IT support people, you have a problem, come here and post asking for help, minutes later you fix it....