'How to find out the data which is positive number and having ' . ' in the data?

I want to find the data which is having positive number . How many records have the positive values. find out the ' . ' in the data We are using db2 database here.

Thanks, katty.

function db2

Solution 1:^[1]

How about

 SELECT * FROM MY_TABLE WHERE MY_COLUMN > 0

and

 SELECT * FROM MY_TABLE WHERE MY_COLUMN LIKE '%.%'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Paul Vernon

'How to find out the data which is positive number and having ' . ' in the data?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]