I can do a select and change a column name using AS.
When I try to project a temp table using the same syntax, I get a syntax error.
ie:Project temp tcolors from colors using Mfg, Style, Prodcolor AS RealColor where StyleNo = '2297'
Can you not do that? Dick Fey Carpet Broker Inc.

