Sunday, 18 August 2013

sql query is not working in case of number is in decimal

sql query is not working in case of number is in decimal

I am using the following query, it is showing the empty result but the
record exist in table. Please let me know how can do it
select * from wp_rg_lead_detail where lead_id=5047 and field_number=1.6
select * from wp_rg_lead_detail where lead_id=5047 and field_number=1.6
in both case query return the empty result.but data exist in table.
data type of the field_number is float in database.

No comments:

Post a Comment