Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why is ISNUMERIC('-') = 1

Status
Not open for further replies.
KCWMS

KCWMS

MIS
Mar 25, 2004
38
US
using SQL SERVER 2K

I was writing a function to strip out non-numerics and found that SELECT ISNUMERIC('-') = 1.

What!!!
 
Sort by date Sort by votes
select convert(int,'-')

brings back 0 so it looks like that's another way of sayinf zero!

select '-'+3 brings back 3!

Interesting.
 
Upvote 0 Downvote
Have a look at this thread for some more interesting info:

thread183-1010578

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
249
grnzbra
grnzbra
JeffModen
  • Locked
  • Question
thread183-1814079 Why do people
Replies
3
Views
176
Mike Lewis
Mike Lewis
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
207
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
2K
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
125
ahmedsa2018
ahmedsa2018

Part and Inventory Search

Sponsor

Back
Top