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 1234»»»

IsNumeric with NULL and Empty String Expand / Collapse
Author
Message
Posted Wednesday, August 3, 2011 8:18 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Comments posted to this topic are about the item IsNumeric with NULL and Empty String

http://brittcluff.blogspot.com/
Post #1153963
Posted Wednesday, August 3, 2011 8:19 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Nice straight forward question - Thanks

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1153964
Posted Wednesday, August 3, 2011 9:36 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 6:59 AM
Points: 1,977, Visits: 525
Whoo.Hooo..

2nd comment on this QOTD. Haven't been able to do that in quite a while. Thanks for the good question. I got it right as I just recently had to deal with a very similar problem about how ISNULL works.

Thanks again!!
Post #1153975
Posted Wednesday, August 3, 2011 11:52 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:02 AM
Points: 1,012, Visits: 1,008
Data_God (8/3/2011)
Whoo.Hooo..

2nd comment on this QOTD. Haven't been able to do that in quite a while. Thanks for the good question. I got it right as I just recently had to deal with a very similar problem about how ISNULL works.

Thanks again!!


I think it is about implicit conversion

Regards,
Iulian
Post #1154008
Posted Wednesday, August 3, 2011 11:52 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:02 AM
Points: 1,012, Visits: 1,008
Thanks for the question

Regards,
Iulian
Post #1154009
Posted Thursday, August 4, 2011 12:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
Great question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1154017
Posted Thursday, August 4, 2011 1:05 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:44 AM
Points: 1,696, Visits: 2,139
DOH!
right answer, wrong reason.
I saw the int, an empty string, an implicit conversion and an ISNULL.
Went straight for the NO without reading the rest.

If anyone feels they have ever been robbed of a point they are welcome to mine today.

good question.
Post #1154029
Posted Thursday, August 4, 2011 2:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Nice, straight forward, implicit conversion question. Greast start to the day.

Cheers


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1154045
Posted Thursday, August 4, 2011 2:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 3:26 PM
Points: 305, Visits: 237
Nice question! I actually guessed on the basis of the first column returning a different result, not the second
Post #1154049
Posted Thursday, August 4, 2011 2:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Good question, thanks.

Mohammed Moinudheen
Post #1154056
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse