Hi All,
I am trying to use the CONVERT() function in an SqlExec() against an Excel spreadsheet. The column starts with numeric values and ends with character values. I want the column to be character, but since the first values located are "numeric" it makes the result column numeric. I cannot figure out the syntax for CONVERT() via SPT. I have tried the following:
?SqlExec(x, "select convert(char(5), proc_code), ...")
?SqlExec(x, "select convert(char, proc_code), ...")
?SqlExec(x, "select convert(varchar(5), proc_code), ...")
?SqlExec(x, "select convert(varchar, proc_code), ...")
Then I noticed in the ODBCJet.Hlp file that SQL_VARCHAR could be used in the CONVERT() function but the following also fails:
?SqlExec(x, "select convert(SQL_VARCHAR, proc_code), ...")
I think SQL_VARCHAR must be a constant but I cannot find it documented anywhere. I tried MSDN Online but couldn't find the definition anywhere.
Please HELP!
THANKS,
Bill Armbrecht
VFP MCP