I'm used to CHARs and VARCHARs having to be single quoted, and I expect
this to be the case for Flamerobin as well (although I know nothing
about Flamerobin, so I may be very wrong). So try

select * from COMUNPOSTAL WHERE provincia='3'

HTH,
Set

Mario Lacunza wrote:

> select * from COMUNPOSTAL WHERE provincia=3
>
> PROVINCIA Varchar(80) CHARACTER SET UNICODE_FSS,