I need to convert the following string into a SQL datetime data type.

"12-dec-2002 1243"

Anyone no how I can do this without splitting it up into a vbdate and vbtime. I would like to do it together.