CREATE TABLE t1(c1 VARCHAR(10) COLLATE Latin1_General_CI_AI)
INSERT INTO t1 VALUES (''car''''s'')
INSERT INTO t1 VALUES (''cars'')
INSERT INTO t1 VALUES (''carps'')
INSERT INTO t1 VALUES (''car-s'')
GO
SELECT * FROM t1 ORDER BY c1 ASC
GO

The output is:

c1         
---------- 
carps
cars
car''s
car-s

(4 row(s) affected)