select statement help - newbie

[cassbiz]

I am trying to get the range between 1 and 11 (ie 1,2,3,4,5,6,7,8,9,10,11)

the select statement is:

select * from zimmer WHERE (Zimmer BETWEEN 1 AND 11)

my output is 1,10,11,100 and 101

I will have to repeat this process with different ranges 12 to 25, 26 to 31, etc...

Any help is appreciated.

[cassbiz]

I found the problem, it is that the field is a varchar field. How do I still continue to search it to produce the results or how do I change the column type from varchar to int?

I am trying to get the range between 1 and 11 (ie 1,2,3,4,5,6,7,8,9,10,11)

the select statement is:

select * from zimmer WHERE (Zimmer BETWEEN 1 AND 11)

my output is 1,10,11,100 and 101

I will have to repeat this process with different ranges 12 to 25, 26 to 31, etc...

Any help is appreciated.

[ronverdonk]

You can cast the Zimmer field (The CAST() and CONVERT() functions take a value of one type and produce a value of another type).

See MySQL manual Casting functions

Ronald :cool: