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 03, 2011 8:18 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
Comments posted to this topic are about the item IsNumeric with NULL and Empty String

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 5,121, Visits: 20,359
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 03, 2011 9:36 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 1,457, Visits: 422
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 03, 2011 11:52 PM
SSC Eights!

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

Group: General Forum Members
Last Login: Thursday, June 13, 2013 6:47 AM
Points: 847, Visits: 770
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 03, 2011 11:52 PM
SSC Eights!

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

Group: General Forum Members
Last Login: Thursday, June 13, 2013 6:47 AM
Points: 847, Visits: 770
Thanks for the question

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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:54 AM
Points: 9,409, Visits: 6,494
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 04, 2011 1:05 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:24 AM
Points: 1,632, Visits: 2,039
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 04, 2011 2:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:19 AM
Points: 1,180, Visits: 744
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 04, 2011 2:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 12, 2012 7:03 AM
Points: 249, Visits: 224
Nice question! I actually guessed on the basis of the first column returning a different result, not the second
Post #1154049
Posted Thursday, August 04, 2011 2:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:29 PM
Points: 2,178, Visits: 3,599
Good question, thanks.

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

Add to briefcase 1234»»»

Permissions Expand / Collapse