View Single Post
  #1 (permalink)  
Old October 18th, 2004, 07:01 AM
sudhakaratp sudhakaratp is offline
Registered User
Join Date: Dec 2003
Location: Bangalore, Karntaka, India.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using COLLATE in SQL SELECT Statements

I have two databases
Db1 is in collation "SQL_Latin1_General_CP1_CI_AS" and
Db2 is in collation "Compatibility_52_409_30003".

Now I need to get records based on the values that i have in these two databases. I have used the following query for that
Select db1..table1.field1,db2..table2.field3 from db1..table1 inner join db2..table2 on db1..table1.field4 = db2..table2.field5 COLLATE SQL_Latin1_General_CP1_CI_AS.

When I run this query, it is returning Incorrect syntax near COLLATE.
Can anyone help me on this. I need to solve this issue @ the earliest.

Expecting a positive reply from my dear forum members.

Thanks in advance