with that T in there.
I'm guessing that T is a mistake so then the string would be a number and
you could just say
select count(*) from numbers where number between #number - 5# and #number +
5#
and if the return is not zero, then there are some in your range.
DRE
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 4:32 PM
To: CF-Talk
Subject: Checking strings
How would I check a string such as:
23T256472549 and make sure there are no other entries in the database
within 5 digits of that? So, 23T256472554 would not be allowed and
23T256472544 would not be allowed (and the inbetweens as well).
Thanks!
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
