+- operator not working

i have the following in one of the Joomla Article content. why the +- not working? results still show the whole list

{tbs}mergeblock=u;db=testdb;sql=SELECT grp, count(id) as ucount FROM testtbl WHERE amt +- 0.0 GROUP BY grp ORDER BY grp{/tbs}

Thanks!

Hi JC,

"+-" is the operator for "if/when" TBS parameters only.
In your case you need the SQL operator ">" in order to define a valid SQL statement.

Since ">" can make troubles in the HTML representation, you can define the SQL criteria differently:

Thanks so much.

any suggestion to fix the following?

(tbs}mergeblock=u;db=testdb;sql=SELECT grp, count(id) as ucount FROM testtbl WHERE amt +- 20 GROUP BY grp ORDER BY grp{/tbs}