"Like" comparison question

#11

David Kaye wrote:

Quote:

Marshall Barton <marshbarton (AT) wowway (DOT) com> wrote:

Sometimes, but not always. IsNumeric will return True for
anything that can represent a number, even somewhat obscure
number styles such as:
+1.234E-3
-1.234D+3
$12.34-
$(12.34)
which makes IsNumeric useless in most situations where you
might expect it to work.

I think this is an unnecessary worry. No account number is going to have
those characters.

How about:
12345D6
543E21

The original question was to see if it was all digits
optionally followed by a letter. Clearly IsNumeric does not
detect some failures to meet the requirement.

--
Marsh

#12

Marshall Barton <marshbarton (AT) wowway (DOT) com> wrote:

Quote:

How about:
12345D6
543E21

The original question was to see if it was all digits
optionally followed by a letter. Clearly IsNumeric does not
detect some failures to meet the requirement.

Dang! Absolutely right. Okay, I'll stick to the solution I posted.

#13

"David Kaye" <sfdavidkaye2 (AT) yahoo (DOT) com> wrote

Quote:

sfdavidkaye2 (AT) yahoo (DOT) com (David Kaye) wrote:

Slight correction. Note the 0 to 9 addition:

select case right$(str$,1)
case "A" to "Z", "a" to "z", "0" to "9"
if maybeok then
isokay=true
else
isokay=false
end if
case else
isokay=false
end select

#14

Thanks to all who replied. It's got to be any number of digits 0-9 (no
other characters) optionally follwed by a single letter (a-z) so my original
way seems as good as any.

Jon

"David Kaye" <sfdavidkaye2 (AT) yahoo (DOT) com> wrote

Quote:

sfdavidkaye2 (AT) yahoo (DOT) com (David Kaye) wrote:

Slight correction. Note the 0 to 9 addition:

select case right$(str$,1)
case "A" to "Z", "a" to "z", "0" to "9"
if maybeok then
isokay=true
else
isokay=false
end if
case else
isokay=false
end select

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

"Like" comparison question

comp.databases.ms-access comp.databases.ms-access

Re: "Like" comparison question - 07-21-2010 , 09:41 PM

Re: "Like" comparison question - 07-22-2010 , 12:43 AM

Re: "Like" comparison question - 07-22-2010 , 03:31 AM

Re: "Like" comparison question - 07-22-2010 , 03:35 AM