|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
BUG - ISNUMERIC('.') = 1
http://www.aspfaq.com/2390
Show quote Hide quote "Howard Swope" <swopehATgigamotoDOTcom> wrote in message
news:eockploLGHA.3100@tk2msftngp13.phx.gbl... > ISNUMERIC('.') returns a value of 1. > > This is bad, right? > > Howard > > Howard Swope wrote:
> ISNUMERIC('.') returns a value of 1. Try this to see why isnumeric returns 1 for this string:> > This is bad, right? > select cast('.' as money) -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. Howard Swope (swopehATgigamotoDOTcom) writes:
> ISNUMERIC('.') returns a value of 1. Yes isnumeric() is bad. It returns 1 if the value can be converted to > > This is bad, right? any numeric data type. Which is quite a useles piece of information. It's not a bug though. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  
Other interesting topics
Why is this statement blocking...
NESTED SQL QUESTION and aggregate function Colour My World BCP output - putting double quotes around text Query Help - Counting Dates and Times Guaranteed consecutive identity values Removing duplicate data Need help setting up linked server Problem with Intead of Insert Trigger Drop & Create sProc |
|||||||||||||||||||||||
