Home Forums SQL Server 7,2000 T-SQL Sorting issue when meet there is ASCII RE: Sorting issue when meet there is ASCII

  • I think this is because you're putting a space before your "Z". And the outer REPLACE doesn't do anything - it just replaces a space with a space.

    John