SELECT *, LEFT(matchtype, 1) AS SortMT1 ; FROM _cdarest ; WHERE !DELETED() ; GROUP BY prospectid, clinkflag, addr_num, predir, addr_name, addr_unit ; ORDER BY confirmed, SortMT1 ; INTO TABLE _uniq>I'm trying to do a SQL select statement through VFP but keep getting the error message SQL: 'Column 'confirmed' is not found'. The field 'confirmed' does exist in my table and the table is open, the alias is right. I don't understand what's wrong. Is confirmed a reserved word in SQL? Should I just change the field name? Here is the exact code that generates the error: