Re: isnumeric()
From: Mike W (mikeotown_at_nospam.msn.com)
Date: 02/21/05
- Next message: Bob Barrows [MVP]: "Re: Not passing back values on an if statement"
- Previous message: Alien2_51: "RE: Sending Email from a job with ActiveX"
- In reply to: Alejandro Mesa: "RE: isnumeric()"
- Next in thread: Steve Kass: "Re: isnumeric()"
- Reply: Steve Kass: "Re: isnumeric()"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Feb 2005 16:14:09 -0500
Hmm. For some reason I thought I had tried this before and it didn't work.
Maybe it's just that I read that its result is not reliable.
"Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
news:C0A5EAE8-AC4E-43A6-924A-22F2836225FC@microsoft.com...
> What is wrong with IsNumeric()?
> http://www.aspfaq.com/show.asp?id=2390
>
>
> AMB
>
>
> "Mike W" wrote:
>
>> why can't we use isnumeric() in a WHERE clause? Is
>> patindex('%[^0-9]%',field)>0 the best way to find out if a string field
>> contains data that can't be converted to numeric?
>>
>>
>>
- Next message: Bob Barrows [MVP]: "Re: Not passing back values on an if statement"
- Previous message: Alien2_51: "RE: Sending Email from a job with ActiveX"
- In reply to: Alejandro Mesa: "RE: isnumeric()"
- Next in thread: Steve Kass: "Re: isnumeric()"
- Reply: Steve Kass: "Re: isnumeric()"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
