Sorting Question

<i><b>Originally posted by : Paul White (pwhite@yahoo.com)</b></i><br />I've come across a perplexing problem.<br />I'm doing a binary search which requires that my universe and subset be sorted identically. <br /><br />My universe is generated from a SQL Server 7.0 stored procedure using the ORDER BY ASC clause.<br /><br />My subset is a user-selected subset, and put into a javascript array, and then calls the sort() method. <br /><br />The problem, SQL Server 7.0 and Javascript sort differently. Given the following Lists: { S, Z, A, _ }, when doing an order by in SQL Server 7.0 I get the following: { _, A, S, Z }, and when I sort my list in javascript i get { A, S, Z, _ }. <br /><br />Is there a way to have SQL Server's Ordre By clause work lexographically based on the ascii table as it appears the javascript sort is doing?<br /><br />Thanks,<br />Paul White<br /><br /><br /><br />