Hi everyone -

(ASA 7)

We are trying to perform a lookup in a varchar column in a table.

The data in the column should be numeric, but it can be
alpha as well (bad spec)

the user can enter a value that will be searched, but they are
lazy (as usual) and don't enter the full number...

The data in the table looks like this
============
001001
021001
031001
01ADT

and the user entered 1001


We are running timing tests using the like and right methods
using the assumptions that the right most characters are the correct
ones...

but i would like some different opinions or methods


take care
tony