Thanks to both of you for your help!!

To answer your question, I'm syncing field name's and auditing 'changed' values based on the Primary Key (This will be the same in both tables)

I'm NOT concerned with non-matching fields......

Thanks Chris,

Thats excellent, Just the job!

My original query is fine...

There is NO problem with the data.

In both mine and your queries there is (currently) one record match.

What I'm saying is that if there is a...

Thanks Jeff,

Your solution deletes the 1 record in the dbo.abn_extract table that exists in the WHERE clause... However, I need to delete ALL records in the dbo.abn_extract table where there...

This is for Christoper's first reply above...

In the first example, records 1,2,3 & 5 have the same Address value, therefore 'Mcmullen Road/N /n/nDarlington/nDurham' must be returned as it's the...

Thanks guys

Just tried out the reply from thegreatsamarth, worked a treat (just altered the UPDATE dbo.TSort line).

Fantastic!!

Thanks Ramesh

I'm getting the following error message though..

Msg 207, Level 16, State 1, Line 8

Invalid column name 'RowNumber'.

I'll check out the other post from thegreatsamarth...

Thanks guys,

I created this function, based on CHARINDEX ... (I didn't mention previously, but the the field I wish to output to has a field size of 30. Hence the...

It is strange that the query requires a database name, but it works!

Many thanks to all that helped me.

Tony, you deserve a star.

Thanks guys.

Firstly, Tony I tried your example with a SELECT statement to begin (and NOT EXISTS), which is fine (displays 2 rows - as expected)

SELECT * FROM

KP.ADD K

WHERE NOT...

Thanks to all concerned.

Sorry I'm late getting back, but I'll try them out now.

Very much appreciated!

It was successful.

Many thanks

If no Status values = 'Checked',

then I don't want to delete any records.

Sorry, I mean the latter.

If any row where Status = 'Checked' then delete ALL records, irresspective of the values.

So if the Customer table has 100 rows and only 1...