Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by dcawvive » Substring comprehension
Add to briefcase
14 posts, Page 2 of 2
««12

Substring comprehension Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
fzaynoun
Posted Friday, November 06, 2009 4:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, June 18, 2011 9:19 AM
Points: 12, Visits: 58
A empty not null. Substring returns null only if expression is null.
Post #815261
Ronzo
Posted Monday, November 09, 2009 10:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 20, 2013 2:06 PM
Points: 502, Visits: 511
Toby White (11/2/2009)
Even though A is empty string versus Null the answer is still obvious given that it is multiple choice. In other words it was obvious that the author had just made a mistake between empty/null since options A and C were so far off.


So...
Always assume that there is a right answer, and if none of the above is not shown, try and figure out which answer would be right assuming the author made a mistake.
Don't like this logic at all. It may result in your passing the test, but it requires you to try and figure out what the author "meant" the answers to be.
I used logic that went like this... if you know two of the answers are wrong, go with the one that might be right (i.e. error). Of course my "logic" failed and yours succeeded, this time.

Have Fun!

Ronzo
Post #815966
L' Eomot Inversé
Posted Friday, November 13, 2009 2:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 7,110, Visits: 7,184
As some previous commenters did, I got this right by guessing what the questioner had got wrong.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #818886
Frédéric van der Plancke
Posted Wednesday, November 18, 2009 7:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 20, 2010 10:04 AM
Points: 54, Visits: 38
Toby White (11/2/2009)
Even though A is empty string versus Null the answer is still obvious given that it is multiple choice. In other words it was obvious that the author had just made a mistake between empty/null since options A and C were so far off.


Except that A is not so far off. I thought along this line: this first select returns the empty string, I don't know what the second one does, but no answer has "this first select returns the empty string", so the only compatible answer is A: error.

Not nice.
Post #820811
« Prev Topic | Next Topic »

Add to briefcase
14 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.