using MAx

[rtdvoip]

Is there a way to use MAX in the following situation?

I have a string '902124543456'
I need to get the closest match in a table with a known index.

ex.

'902124543456' - compare value

table values

index prefix
1 90
1 90
1 90212

any thoughts hints or suggestions?

thanks,
rtdvoip

 

[SQLBill]

I don't know if it works with INTEGER, but have you checked out the SOUNDEX command? Refer to it in the Books OnLine.

-SQLBill

 

[rtdvoip]

It is all string compares not integer. I will look into the soundex as well. thanks.