Re: compare float column

2015-01-13 Thread Devopam Mittra
please try the following and report observation: WHERE long = CAST(-41.338276 AS FLOAT) regards Devopam On Tue, Jan 13, 2015 at 2:25 PM, Patcharee Thongtra patcharee.thong...@uni.no wrote: Hi, I have a table with float columns. I tried to query based on the condition on a float column

Re: compare float column

2015-01-13 Thread Patcharee Thongtra
It works. Thanks! Patcharee On 01/13/2015 10:15 AM, Devopam Mittra wrote: please try the following and report observation: WHERE long = CAST(-41.338276 AS FLOAT) regards Devopam On Tue, Jan 13, 2015 at 2:25 PM, Patcharee Thongtra patcharee.thong...@uni.no mailto:patcharee.thong...@uni.no