Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialNatalie Jensen
1,425 PointsWhat is wrong in the following? > SELECT * FROM products WHERE price <= "10,99" ;
.
3 Answers
Jason Anders
Treehouse Moderator 145,860 PointsHey Natalie,
I think it is because you have a comma in $10.99 instead of a period. Change that and give that a try.
Keep Coding! :)
Steven Parker
231,261 PointsI would have guessed it was because of the comma and the quotes around the value.
But I tried it in the challenge, and apparently it works fine with or without the quotes! But you can't count on that working in a real database. They typically will not let you put quotes around a number (or leave them off a string).
Also, at least some database engines allow you to set session variables to accommodate regional numeric formats that might actually use the comma as the decimal separator.
Natalie Jensen
1,425 Pointsthanks.. It worked. haha.. (: