[drupal-support] use of db_rewrite_sql to change the "order by"

[Dan Robinson]

Is there any way to use db_rewrite_sql to change the "order by" clause 
of an sql statement?

Thanks,

Dan