What is requiring to convert VFP character fields to SQL Server's Text datatype?

-Mike

>A really basic question for a first-time SQL job:
>
>Character fields in VFP must be converted to "Text" in SQL Server. SQL Server does not permit "ordering" on Text fields. If, for instance, we move "Name" into a table, how do we display names alphabetically?