Subject Re: DATE VALUE in SQL From Mustansir Ghor <mustan31@hotmail.com> Date Fri, 16 Nov 2018 08:03:12 -0500 Newsgroups dbase.getting-started Dear Wian Yes. The mystery was to add 0.00 the 2 decimals Thanks Regards Mustansir WJS Wrote: > On 2018-11-16 09:16 AM, Mustansir Ghor wrote: > > Dear Wian > > > > Thanks. Yes it worked except for numeric field rate. Here literal value is accepted but not variable. > > > > Strange. Did you get any error msg ? If so, what was it. > > Either the table field is not numeric or the value is not numeric but > something like a double. > To find out use ?type("mrate") > If the answer is not numeric, you can add 0.00 to the variable and then > try again. > > Wian