How to add quotes to each result returned in a column.
I am a newbie, so I apologize in advance. I have a query within a .odc file. I am trying to append quotations or something similar to a datetime variable, so that excel does not format the values as dates. I have tried: SELECT '"' + MYTABLE.MYDATETIME + '"' FROM.... But when I open this file, I get the error: "Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If I do: SELECT MYTABLE.MYDATETIME FROM.... The query runs fine.