I think you can use something like this:
SELECT *
FROM tbl_Accounts
WHERE ISNUMERIC(Account_no) = 1 AND Account_no BETWEEN 100000 AND 999999
ISNUMERIC returns 1 when the input _expression_ evaluates to a valid integer,
floating point number, money or decimal type; otherwise it returns 0. A return
value of 1 guarantees that _expression_ can be converted to one of these numeric
types.
Let me know if it works,
Mario
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 3:42 PM
To: CF-Talk
Subject: Re: sql 'is numeric' question
Wurst, Keith D. wrote:
> does anyone know if you can build in an 'is numeric' validation into a where
> clause of a sql statement? i would also like to check to see if the column
> im working with has 6 digits (places). thanks for the help.
WHERE column BETWEEN 100000 AND 999999
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
