John,

This gives an invalid order by clause error:

create cursor x1 ( c1 c(10) )
insert into x1 values ( "1 test" )
insert into x1 values ( "A test" )

select * from x1 order by isdigit( c1 )


>David, VFP does permit referencing a column in the ORDER BY clause that isn't in the result set.