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 @ 7:59 AM
Points: 5,470, Visits: 23,475
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 03, 2014 5:32 AM
Points: 1,735, Visits: 488
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: Wednesday, February 05, 2014 6:49 AM
Points: 861, Visits: 793
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: Wednesday, February 05, 2014 6:49 AM
Points: 861, Visits: 793
Thanks for the question

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 12,197, Visits: 9,150
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: 2 days ago @ 5:02 AM
Points: 1,652, Visits: 2,075
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: 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 04, 2011 2:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 03, 2013 1:55 AM
Points: 298, Visits: 236
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: Monday, April 14, 2014 5:49 PM
Points: 2,263, Visits: 3,758
Good question, thanks.

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

Add to briefcase 1234»»»

Permissions Expand / Collapse