I think that oracle is expanding it so that it works ... if the value passed isn't 0 but what's happening is the decode function is looking at it as another if/else block.<BR><BR>Any ideas?< ...