Subject Re: DATE VALUE in SQL From WJS <warra@nowhere.com> Date Fri, 16 Nov 2018 12:38:51 +0200 Newsgroups dbase.getting-started 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