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 mailto:patcharee.thong...@uni.no>> wrote: Hi, I

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 col