Originally posted by raf
no row select ( there are rows with flag=1 and cod<>'M')
No, there obviously aren't any such rows! I bet the only combinaton you have there are:

- flag=1, cod='M'
and/or
- flag=1, cod IS NULL !!!!

If something is NULL, then you can't say it's <>'M'.