All pastes #372613 Raw Edit

Stuff

public text v1 · immutable
#372613 ·published 2007-02-26 05:26 UTC
rendered paste body
SNO,DESTNO,RATE
1,91,45
2,914373,97
3,9144,79


when i supply,

DESTNO  i need to get the best match and a single value,

91         -> 91
914492345  -> 9144
9143732323 -> 914373
914372     -> 91

How to form the sql query for the above to get the best and only single  value?