[GENERAL] Problems with operator '%' within a select

[Gabriel Fernandez]

Hi !

I've just had some problems using the operator '%' within a select.
This is an example:

"select codigo from codis where codigo like '%3'  "

And i've found that all the rows which contains more than one three
won't be selected.
(For example: values 'a34ree3', '34fg3')

It seems as if you put only one character with '%' it will select only
the rows wich contain only one time this character.

Am I wrong ?

Gabi :-)



************