I want to load all of the fields from a SQL database but 2 of the fields need to be changed via the CAST command.
So far all I have is:
SELECT CAST(var1 AS VARCHAR(30)) FROM table1") dsn(db1)

This command only quesries the var1 field.
1)How do I load the rest of the fields?
2) How do I perform the same CAST manipulation to another variable at the same time?

Thanks!