Superb, tried that and got all the data I needed out! Thank you!

That worked great Flo, guess that serves me right for being lazy 😉

Whisk back in the kitchen!

Thanks very much and have a good one!

Mark

Actually Florian, sorry I misunderstood your answer... I'll try using a query instead of deleting it manually in sql management studio...

Hi Florian,

yeah I had done that right at the beginning, before putting the data into the columns. put 26.9 into the column [ELE.MC] for example and when i go to...

That all seems to be working great. Big thank you to both of you! If SQL were a swimming pool, I'd have my head under water in the shallow end......

Thanks for the Gail, I dropped WHERE NOT EXISTS (SELECT 1 FROM newsarchive WHERE newsarchive.title = inserted.title) into my trigger, but when it executes I get the error:

"Cannot resolve the...