Not in a single statement. But you can easily build the SQL statement programmatically, either in a SQL procedure or a Xojo method, by getting the field names of the table and looping through them, skipping those you don’t want.
/* Get the data into a temp table */
SELECT * INTO #TempTable
FROM YourTable
/* Drop the columns that are not needed */
ALTER TABLE #TempTable
DROP COLUMN ColumnToDrop
/* Get results and drop temp table */
SELECT * FROM #TempTable
DROP TABLE #TempTable
Thanks… I knew about those methods… Since this is a VIEW and not a derived table, it would have had to been a single statement… So I’ll just carry a bit extra baggage… its not a big deal…