Why doesn’t ISNUMERIC work correctly?

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  October 28, 2010 at 2:42 am

  #228450

  It's an old subject, I know. Still, the problem of using ISNUMERIC as an "IsAllDigits" function still has people thinking that ISNUMERIC doesn't work correctly. I submitted another "SQL Spackle" article on the subject. I had written it as a response to a post a long time ago. I updated the verbage and one of the examples and submitted it via the "write for us" link.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• WayneS

  SSC Guru

  Points: 95461

  More actions

  October 28, 2010 at 10:41 pm

  #1243982

  So you've got two SQL Spackle articles already done? You really are quite the hot-shot.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  October 29, 2010 at 6:08 am

  #1244084

  WayneS (10/28/2010)

  ---

  So you've got two SQL Spackle articles already done?

  I do. I also ran into a couple of problems at work recently and solved them. They're also something that a lot of people know about but would still make good SQL Spackle articles. Since they're so short, I should be able to post what they are in this forum section over the weekend and submit them.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)