Check this out -

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/tsqlref/ts_da-db_7ory.asp


You can specify collate at end of ur statement.

e.g.

select *
from fc, products
where fc.product_name = products.product_name
COLLATE SQL_Latin1_General_CP1_CI_AS

Nice one.





> Hi!

> well, I cannot believe I am having problems with this kind of 
queries ... 
b> ut I guess I am missing something important.

> I have got two tables :

> Create table fc
(> week_no int,
 > product_name  varchar(100),
 > amount  int)

> Create products
(> id   numeric,
 > product_name varchar(256)
)> 

> I just need to join them ... and I do it as follows:

> select *
f> rom fc, products
w> here fc.product_name = products.product_name

> 
C> an somebody tell me, why I get the following error?

> "Server: Msg 446, Level 16, State 9, Line 1
C> annot resolve collation conflict for equal to operation."

> Thanks a lot!

> Carmen