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 trial

Databases

Natalie Jensen
Natalie Jensen
1,425 Points

What is wrong in the following? > SELECT * FROM products WHERE price <= "10,99" ;

.

3 Answers

Jason Anders
MOD
Jason Anders
Treehouse Moderator 145,858 Points

Hey 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
Steven Parker
229,981 Points

:point_right: I 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
Natalie Jensen
1,425 Points

thanks.. It worked. haha.. (: