Hi,

I´ve a table a table with a varchar field "Codigo".
I use firebird 1.5 and a sentence like "select * from table where codigo
like "046"" only some of the rows with codigo=046 are selected, but with
this sentence:
"select * from table where codigo like "%046%"" all rows are selected. what
are happening? with the first sentrence all or none rows must be selected,
or I´m wrong

thanks


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