First the data (already sorted? I doubt it), anyway ...
CREATE TABLE [cpqa].[tbl_RM_maxNvarchar](
[data][nvarchar](323)
)
INSERT INTO [cpqa].[tbl_RM_maxNvarchar]
VALUES('transworldairlines')
Now the target for an indexed version of that "sorted" table.
CREATE TABLE [cpqa].[tbl_RM_maxNvarcharX](
[x][int]IDENTITY(1,1),
[data][nvarchar](323)
)
INSERT INTO [cpqa].[tbl_RM_maxNvarcharX]
SELECT * FROM [cpqa].[tbl_RM_maxNvarchar]
Execute this query:
SELECT * FROM [cpqa].[tbl_RM_maxNvarcharX]
And get this result:
x data
~~~~~~~~~~~~~~~~~~~~~~~
1 transworldairlines
And finally sort using ORDER BY [x] ASC.