Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

ISNUMERIC Expand / Collapse
Author
Message
Posted Wednesday, September 29, 2010 2:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 6:23 AM
Points: 1,082, Visits: 4,887
A good question that has taught me two things:

1. You can't trust SQL's ISNUMERIC function
2. You can build a recursive CTE - although I'm no sure I would want to

If anyone else has examples of CTE's I bet they'd make for some tricky questions?

Thanks
Post #994979
Posted Wednesday, September 29, 2010 3:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 5,794, Visits: 8,006
jts_2003 (9/29/2010)
2. You can build a recursive CTE - although I'm no sure I would want to

Recursive CTE'sare an invaluable tool when working with hierarchic data (like employee/supervisor relations, parts built of parts built of parts, genealogy data, etc). There are some examples of this in Books Online.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #995028
Posted Wednesday, September 29, 2010 3:04 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 1:59 PM
Points: 444, Visits: 270
Very nice question. And one more time I see that 'isnumeric' works in a way which is far away from our expectations. Always used custom made functions instead.


Post #995624
Posted Friday, October 08, 2010 9:03 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 07, 2014 2:34 PM
Points: 885, Visits: 188
Great question! Now that I know how "liberal" is numeric is, I will be more careful with it.
Thanks!!!
Post #1001383
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse