<div>
the values are in 0.00 format i am still getting the records.
</div>


the values are in 0.00 format i am still getting the records.

<div>
hmmm.... how do you &quot;display&quot; the values?<br />
<br />
possibly, the values are close to 0, like 0.0001, and the display shows the &quot;rounded&quot; value.<br />
or, you have NULL, and the display shows 0.00 instead.
</div>


hmmm.... how do you "display" the values?

possibly, the values are close to 0, like 0.0001, and the display shows the "rounded" value.
or, you have NULL, and the display shows 0.00 instead.

<div>
<div class="content wysiwyg-content">
I have money datatype column. Some of the rows have value for the column as 0.00. I need to filter those records.<br />
<br />
Can you please tell me how the where caluse shd be?
</div>
</div>


I have money datatype column. Some of the rows have value for the column as 0.00. I need to filter those records.

Can you please tell me how the where caluse shd be?

money datatype

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.