String within 5 digits....please advise.

[kelly]

Did anyone have an idea of how I would accomplish this:

I have a list of serial numbers (ex. 23T222222222, 23T222222223,
23T452365789). I need to check and see if an of the numbers are within 5
digits of each other. So, I was taking the prefix and suffix:
<cfset Prefix = Left(ListGetAt(form.serialnumber), 3)>
<cfset Suffix = RightListGetAt(form.serialnumber), 9)>
and comparing them to records in the db.

Is there a way to do this without a query? Can I compare using an if
statement?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---