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: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
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: Today @ 5:15 AM
Points: 1,924, Visits: 515
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: Saturday, October 11, 2014 4:03 AM
Points: 1,005, Visits: 988
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: Saturday, October 11, 2014 4:03 AM
Points: 1,005, Visits: 988
Thanks for the question

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 13,277, Visits: 11,066
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: Today @ 3:42 AM
Points: 1,672, Visits: 2,104
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 3, 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 4, 2011 2:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
Good question, thanks.

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

Add to briefcase 1234»»»

Permissions Expand / Collapse