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, September 23, 2014 9:12 AM
Points: 1,103, Visits: 4,899
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: Today @ 4:48 PM
Points: 6,021, Visits: 8,290
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, September 11, 2014 2:06 PM
Points: 448, Visits: 280
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 8, 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: Wednesday, August 20, 2014 1:39 PM
Points: 922, Visits: 197
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