Microsoft ODBC type conversion
Posted on 2001-08-29
Are there any type conversion functions in Microsoft ODBC drivers? For instance, while using standard textfile driver I've tried both CONVERT, CAST ... with no result. The driver says 'Function CONVERT not defined' or such like that. I investigeted driver properties and I can see, that SQL_CONVERT_FUNCTIONS.SQL_FN_CVT_CONVERT is enabled... so maybe I use wrong syntax?