Re: How to retrieve rows with empty value in numeric(12,8) columns

[Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>]

select * from table where lat=NULL;

Above query also returns 0 rows.

Thanks
Bèrto ëd Sèra wrote:

Hi,

haven't checked this personally, but first of all... what if they are simply stored as NULLs?

Bèrto

On 6 December 2011 13:39, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote:

Dear all,