>My SQL Server tables use varchar fields, and I would like to create a remote view that accesses those fields and orders the results by one of the fields. But the View Designer will not let you sort the results by a varchar field. Is there a way to do it?

You can index cursor if it's not very big.