quote:

---

Originally posted by OldMySQLUser

I have a script for MS Server 2005:
(there aren't many records so I haven't bothered with fulltext search)

use Debt
select * from dbo.Diary as d

JOIN Debtor as dt
ON d.DebtorID = dt.DebtorID

JOIN Debt as db
ON db.DebtID = dt.DebtID

JOIN Portfolio as p
ON p.Code = db.Code

where
(Description like '%refund%'
or Description like '%overpayment%'
or Description like '%over payment%')

AND (db.Code = 'P0010' or db.Code = 'P0011')

which find a collation error between the tables. I have tried tagging 'collate database_default' onto the script so:

use Debt
select * from dbo.Diary as d

JOIN Debtor as dt
ON d.DebtorID = dt.DebtorID

JOIN Debt as db
ON db.DebtID = dt.DebtID

JOIN Portfolio as p
ON p.Code = db.Code

where
(Description like '%refund%'
or Description like '%overpayment%'
or Description collate database_default like '%over payment%')

AND (db.Code collate database_default = 'P0010' or db.Code collate database_default = 'P0011')

without success.

How can I resolve this please?

---

quote:

---

Originally posted by visakh16

what was the initial error?

---