convert string into date

i got a string field from excel and want to import to SQL server
the date field is "28-Nov-05", How can i convert it into date field '
thanks a lotHi,
what about : SELECT CONVERT(Datetime,'24-Nov-2005')
HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Good old Books Online:
http://msdn.microsoft.com/library/d...br />
2f3o.asp
Take a good look at the style table for datetime/smalldatetime types. If
your exact style is not listed, try one that is similar.
ML
http://milambda.blogspot.com/