I have a table, Table1, with 4 columns - SvcCode,Type,From, and Description. The "From" column contians values, both numeric an alpha numeric. I need to be able to find where a specified value fits in the "From" column. The value returned should be the floor value in the range.

For instance, lets assume there are three values in the "From" column, 00100,00200, and 00300. If the user entered 00110 we would want it to return 00100.

Any ideas on how to write the query to accomplish this?

 i guess you should check the third digit of the entered data with the data in your from table and with the one it matches return that to the user.you can get the third digit by using substring.

That would work in some situations but what about the scenario's where the "From" column contains values like 00110, 00120, 00130,00210,00220,00230, etc and the value entered is 00115? Or what bout when the enterd value is alphanumeric? Ideas?

maybe the FIRST Function can help

SELECT FIRST(Table1.FROM)
FROM Table1
WHERE Table1.FROM <= YOURINPUT
GROUP BY ...
ORDER BY ...

"Life is a Database"

there is also a Max(columnname) MySQL function built in, may be of use???

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

http://www.mysqlfreaks.com/statements/27.php

more info.......

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt