Jump to content
Ch 2 Pg. 115 Use Of Between Statement For Text Range
1 reply to this topic
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.
Posted 03 April 2013 - 01:20 PM
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