I don't think that does it? I'm looking for something like this. The first two fail because they think DB_ID is a column and the last one does nothing.

,iif...

I am having trouble working out exactly what you are asking but see below it may help you?

UPDATE

--table to update

Values1

SET

--column you want the value inserted...

sorry GilaMonster, didn't see your response,

um - ok I'll have a look at that thanks!

I'm pretty sure you cant use variables in views, I have decided to take them out which isn't the end of the world.

I haven't worked out how to create...

that works perfectly thanks for your help! I need to do some further research to understand how it works but that's excellent.

Cheers