Between and comparison operators problem.

[Ibrahima Baradji]

Hi,

When I execute the following statement:
SELECT ID FROM myTable where ID BETWEEN '1' AND '2'

I have the folowing result:

1000260
1000262
1000263
2

same result When I execute:
SELECT ID FROM myTable where ID >= '1' AND ID <= '2'

why the value '1000260', '1000262', '1000263' are returned ?

and why I have no result when I execute:
SELECT ID FROM myTable where ID BETWEEN '1' AND '1'

Thanks.