Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-15 : 10:18:37
|
| Karen writes "We are on the bandwagon for moving many IBM mainframe databases to SQL Server or other Client/Server databases. One of the problems we can't seem to figure out is how to handle sorting. We are used to seeing a Product Code sorted with alpha first & numbers last on our mainframe. Now on SQL Server we are dealing with numbers first & alpha last in our order by clauses. Sometimes we need to 'marry' the results of the mainframe data with the Sql Server data, not an easy task to do with good performance. I was trying to figure out if Collation Support in SQL Server 2000 would help us out in this area. Does anyone else have tips or ideas on this sorting problem? We would like to have an 'Order By Product Code EBCDIC'." |
|
|
|
|
|
ASCII / EBCDIC Sorting