Jump to content


Photo

Ch 2 Pg. 115 Use Of Between Statement For Text Range


  • Please log in to reply
1 reply to this topic

#1 headguy

headguy

    New Member

  • Members
  • Pip
  • 1 posts

Posted 24 March 2013 - 06:57 AM

CH 2 pg. 115 Use of BETWEEN for text range

SELECT drinks_name FROM easy_drinks
WHERE main BETWEEN 'P' AND 'S';

doesn't include drinks with main ingredient of soda.
Similar problem exists in text roping using comparison operators.

#2 drewdin

drewdin

    Super Veteran Member

  • Members
  • PipPipPipPipPipPipPipPipPipPipPip
  • 608 posts
  • Gender:Male
  • Location:Boston

Posted 03 April 2013 - 01:20 PM

CH 2 pg. 115 Use of BETWEEN for text range

SELECT drinks_name FROM easy_drinks
WHERE main BETWEEN 'P' AND 'S';

doesn't include drinks with main ingredient of soda.
Similar problem exists in text roping using comparison operators.


It stops at S but does not include S, Make it T and I bet it will work...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users