Here is a simple example how to deal with case if your date strings do come in different languages. Yes, you will need to use cursor (or loop) in order to process data in different languages separately...

declare @tSrc table (ml_dt varchar(50))

declare @language table (tongue varchar(20))

declare @tDst table (dt datetime)

declare @currentlanguage varchar(50)

INSERT @tSrc VALUES ('déc 5 2007 12:00AM'),('dec 5 2007 12:00AM'),('dez 5 2007 12:00AM')

INSERT @language VALUES ('English'),('French'),('German')

SET @currentlanguage = @@LANGUAGE

DECLARE @tongue VARCHAR(50)

DECLARE lang_c CURSOR FORWARD_ONLY FOR SELECT tongue FROM @language

OPEN lang_c

FETCH NEXT FROM lang_c INTO @tongue

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT @tongue

SET LANGUAGE @tongue

INSERT @tDst SELECT CASt(ml_dt AS DATETIME ) FROM @tSrc WHERE ISDATE(ml_dt) =1

SET LANGUAGE @currentlanguage -- otherwise, you will need to specify language in the list in the previous tongue (Deutsch instead of German)

FETCH NEXT FROM lang_c INTO @tongue

END

CLOSE lang_c

DEALLOCATE lang_c

SELECT * FROM @tDst