I'm trying to convert a column from a number to a varchar-like column in a Access SQL query.
SELECT MSysObjects.Name, Convert(varchar,MSysObjects.Type) AS xtype, MSysObjects.DateCreate AS refdate FROM MSysObjects WHERE Type=5 OR Type=1 AND NOT Left(Name,4)='MSys'
The problem with this code is that apparently, that function doesn't exist with Access.
Additionally, I was just using the Replace() function in the query when I wrote the query in Access and it worked but it won't work from the outside using either the Access Driver or the Jet 4.0 Driver. So, since I couldn't do that, I was going to update the recordset after the fact but I can't do that until I get the field type to be something other than an integer.