Sorry 
my mistake

- table COTE_TVA owner AdriSoft without column ANULAT
- SysDba  add column ANULAT (smallint)
-SELECT distinct tip_o,desc_o FROM COTE_TVA where anulat=0      return zero rows
- SysDba drop column ANULAT
- owner AdriSoft add column ANULAT
- SELECT return zero rows
- drop table COTE_TVA
-owner AdriSoft recreeate table COTE_TVA with column ANULAT
- SELECT work OK

thx for replay

sorry for my Tarzan English




________________________________

>Firebird v.2.5.1
>
>Example:
>SELECT distinct tip_o,desc_o FROM COTE_TVA where anulat=0

Explain "command does not work".

./hb

[Non-text portions of this message have been removed]