numerical ordering

[doddo]

Hi, I usually use MySQL so haven't come accross this problem before.

I have an integer field, and say I want to pull up all entries with values between 18 and 20, I would normally use:

SELECT * FROM users where ch_4_year>=18 and ch_4_year<=20

MS SQL appears to consider the following to be ascending

1
10
11
12
13
14 etc.

Therefore the above command also pulls out values of
2 as well as 18,19,20.

Does anybody know how to avoid this?

Thanks in advance
Rich

 

[foxdev]

Rich, even though you said its an integer value, it looks like it is actually character. Are you going through some other layer or process that may be converting them from Int to Char? Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[doddo]

you're absolutely right, sorry about that!