cast column float

2015-05-27 Thread patcharee
Hi, I queried a table based on value of two float columns select count(*) from u where xlong_u = 7.1578474 and xlat_u = 55.192524; select count(*) from u where xlong_u = cast(7.1578474 as float) and xlat_u = cast(55.192524 as float); Both query returned 0 records, even though there are some

Re: cast column float

2015-05-27 Thread Bhagwan S. Soni
could you also provide some sample dataset for these two columns? On Wed, May 27, 2015 at 7:17 PM, patcharee patcharee.thong...@uni.no wrote: Hi, I queried a table based on value of two float columns select count(*) from u where xlong_u = 7.1578474 and xlat_u = 55.192524; select count(*)