>>If I remove the ORDER BY clause, it works. Any ideas?
>
>Make your ORDER BY expression the last field selected (name it fld9), then order by fld9. This works - I've done it a number of times.

That worked great. Thanks!