Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Query

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2009-05-11 : 11:28:50
I need a function which returns whether the value is numeric or not.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-11 : 11:38:55
isnumeric()
also refer to
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59049&SearchTerms=isnumeric
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/enhanced-isnumeric-function.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2009-05-11 : 11:49:12
THanks.

can i have anything for the dates also.
Go to Top of Page

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2009-05-11 : 11:54:04
My req's i want to pass three values of varchar types which has month
day ,year then the function should check if it valid date or not..

Thanks for your help
Go to Top of Page

dsindo
Starting Member

45 Posts

Posted - 2009-05-11 : 20:29:50
isdate() would evaluate if is a date or not.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-05-12 : 01:41:24
quote:
Originally posted by dsindo

isdate() would evaluate if is a date or not.


It is not always reliable
Refer http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -