Title: SQL ROUND and (
Last modified: August 30, 2016

---

# SQL ROUND and (

 *  [florian_r](https://wordpress.org/support/users/florian_r/)
 * (@florian_r)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/sql-round-and/)
 * Hi everyone, I totally love the plugin and it really works like a charm!
    However,
   I have one problem: I have a perfectly valid sql statement which includes a SELECT
   ROUND (XY, 2) statement. I tried it in phpmyadmin. It works. However, abase does
   not seem to work with the ROUND argument in the query. But I definitly need to
   round these values. Any help?
 * Second I have another query where there is a “< 10” statement in it. This does
   not work either. The other way around (“> 10”) works. Does anybody have a tip
   on either of these issues?
 * Thank you in advance.
 * Cheers,
    Florian
 * [https://wordpress.org/plugins/abase/](https://wordpress.org/plugins/abase/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [florian_r](https://wordpress.org/support/users/florian_r/)
 * (@florian_r)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/sql-round-and/#post-6650865)
 * okay people, the SMALLER THAN Isseu is solved: it works if you use the html-reference
   of the “<“- sign which is `<` (i.e. less than = lt)
 * See all the reference names here: [http://www.ascii.cl/htmlcodes.htm](http://www.ascii.cl/htmlcodes.htm)
 * The ROUND Problem mentioned above persists. Please help me out on how to make
   the regular SELECT ROUND statement work in ABASE.
 * Thanks!
 *  Thread Starter [florian_r](https://wordpress.org/support/users/florian_r/)
 * (@florian_r)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/sql-round-and/#post-6651058)
 * Hey folks, I’m still struggeling with the ROUND-error in the ABASE statement:
   In my installation ABASE does not deal with the otherwise (e.g. phpMyAdmin) working
   MYSQL statement. Please someone respond with a hint.
 * Sincere thanks!
 *  Thread Starter [florian_r](https://wordpress.org/support/users/florian_r/)
 * (@florian_r)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/sql-round-and/#post-6651110)
 * and it is still going on… listen guys, even if its a total nobraine: I dont see
   it right now – please help.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL ROUND and (’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/abase.svg)
 * [ABASE](https://wordpress.org/plugins/abase/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/abase/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/abase/)
 * [Active Topics](https://wordpress.org/support/plugin/abase/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/abase/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/abase/reviews/)

## Tags

 * ["round](https://wordpress.org/support/topic-tag/round/)
 * [where](https://wordpress.org/support/topic-tag/where/)

 * 3 replies
 * 1 participant
 * Last reply from: [florian_r](https://wordpress.org/support/users/florian_r/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/sql-round-and/#post-6651110)
 * Status: not resolved