quote:

---

Originally posted by nigelrivett

As opposed to what?
It's a collation - depends on how you want to use the data as to which you need to use.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

--English characters will be sorted first as r default collation for the column is  SQL_Latin1_General_CP1_CI_AS
create table t
(
	ID	int identity(1,1) primary key,
	data	nvarchar(30)
)
go

insert into t
select N'ABC'
union all 
select N'PQR'
union all
select N'??????'
union all
select N'aaa'
union all
select N'?? ???? ???'
union all
select N'??? ????
'
select * from t order by data

DROP TABLE t

CREATE TABLE dbo.CollationDemo(
	Latin1_General_CI_AS varchar(10) COLLATE Latin1_General_CI_AS
	,SQL_Latin1_General_CP1_CI_AS varchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS
	);

INSERT INTO dbo.CollationDemo VALUES('CO-OP', 'CO-OP');
INSERT INTO dbo.CollationDemo VALUES('COOP', 'COOP');

SELECT *
FROM dbo.CollationDemo
ORDER BY Latin1_General_CI_AS;

SELECT *
FROM dbo.CollationDemo
ORDER BY SQL_Latin1_General_CP1_CI_AS;

DROP TABLE dbo.CollationDemo

quote:

---

Originally posted by coolbudy

quote:

---

Originally posted by nigelrivett

As opposed to what?
It's a collation - depends on how you want to use the data as to which you need to use.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

You have any simple example for it?

---