Trying to find an approximate match in a Column

[ankur2207]

Hi Sir,

So I have a column of integer values and generating random number. Now I need to find an exact or approximate match of that Random Number.

For Example:
Generated Random Number=55355
Exact match=55355
but when exact match is not in the data then we'll find approximate match and it can be 55280.

Kindly help me solving this and many thanks in advance.

Regards,
Ankur K