Login
Latest Code Ticker for SQL.
Daily Code Email
|
|
| |
|
| 
| Submitted on: 11/14/2003 7:09:17 AM
By: Jonathan Spinks
Level: Intermediate
User Rating: Unrated
Compatibility:SQL Server 2000
Users have accessed this code 1008 times.
|
|
| | | The is numeric function can return some weird results isnummeric('.'), isnumeric('+'), isnumeric('-'). Yes, Yes and Yes. These are not the most helpfull results. Heres a little function that tells it like it is.
| | | | | code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
--**************************************
--
-- Name: Is Num
-- Description:The is numeric function c
-- an return some weird results isnummeric(
-- '.'), isnumeric('+'), isnumeric('-'). Ye
-- s, Yes and Yes. These are not the most h
-- elpfull results. Heres a little function
-- that tells it like it is.
-- By: Jonathan Spinks
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/vb/scripts/Sh
-- owCode.asp?txtCodeId=783&lngWId;=5--for details.--**************************************
--
CREATE function dbo.fnIsNum(@in sql_variant)
returns bit
Begin
DECLARE @char char(255)
SET @char = ltrim(cast(@in as char(255)))
--Use isnumeric TO CHECK FOR the obvious
IF (isnumeric(@char) = 0) RETURN 0
--Remove dp TO allow numbers WITH no leading zero ie .321
SET @char = replace(@char, '.', '')
--Remove minus sign TO allow FOR negative numbers
SET @char = replace(@char, '-', '')
--If the first character IS a digit THEN it is numeric
RETURN CASE WHEN (ascii(@char) > 47 AND ascii(@char) < 58) THEN 1 ELSE 0 END
End
| |
Other 2 submission(s) by this author
| | | | | Report Bad Submission | | | | | Your Vote! | |
See Voting Log | | | | Other User Comments |
There are no comments on this submission.
| | | Add Your Feedback! | Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
| |
|
|
