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?