Hi Is there anyone work with SQL XML before to help me. Please help me if you can. I had tried all the options I could but no luck.

Hiya...

OMG you guys are really really helpful. It works fine. I have to work on upto 10 data to compare. Not sure I am doing it right by comparing 2...

Hello,

Sorry yess I did update the original post. Okay here are the complete code which I just paste in a new query of MS SQL 2008.

DROP TABLE [dbo].[vwCourseClass]

GO

CREATE TABLE...

The Dixie Flatline (6/2/2011)

---

You can test the rightmost two characters by using the RIGHT() function. In your example, try adding this to the WHERE clause.

AND RIGHT(dbo_vwCourseClass.ClassTitle,2) <> RIGHT(dbo_vwCourseClass_1.ClassTitle,2)

However,...

Sorry this is my first log in a question about getting help. Thanks for your kind advice. I have updated it.