dcdanoland

thanks

Is it the ((2*isActive)-1) that is the scary looking part of it . That's just to change the 1 and 0 we have in the isActive columns to a 1...

Alternatively you could have a computed column on the Region table which is the id of the region when it is active and the negative of the id when it...