Can these two SELECT statements be mergerd into one with the ORDER BY happening first?

SELECT [controlNum], [transDate] FROM [EDI_Control].[dbo].[InterchangeControl] WHERE controlNum > 0 ORDER BY [transDate];

SELECT [controlNum], [transDate] FROM [EDI_Control].[dbo].[InterchangeControl]...

Yes I know that. I think a 10 is trying to be inserted again because of the way the table is sorted... Mapforce sees the 9 as the last...

1. Good question. I made it char(9) because the field I'm mappping it to is a 9 character fixed length field. That was my thinking at the time.

2....