>VFP backend:
>
>Why will the PADL() in this order by not work?
>
>SELECT * FROM table1 ORDER BY street, st_type, st_prefix, st_suffix, city, PADL(ALLTRIM(number),8,'0')
>
>It bombs on the PADL() portion. The backend is VFP not SQL or Oracle.
Humm, I did something similar (in VFP 6) more or less like this:
select expr1, expr2, ... order by 1, 2
Where expr1 and expr2 can be replaced by any UDF.
With the asterisk, you might simply add additional fields:
select expr1, expr2, * ... order by 1, 2
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)