.csv Dates in 20-Oct-06 fomat won't import/translate into VStuido

[Barry G. Sumpter]

Hi all,

In VStuido I've got a VarChar field which contains a date in the format of
20-Oct-06.
It's the only way I could get the data in a VStuido DB.

VStuido can't translate the data by simple changing the field type to date.

Does anyone have a SQL statement to change the format into 20/08/2006 ?





  Thanks,
     Barry G. Sumpter