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

2000-01-19 Thread Sean Carmody
Gabriel Fernandez wrote: [Snip] > 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 'a

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

2000-01-19 Thread 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 pu