Subject Re: converting text to value in SQL
From Heinz Kesting <>
Date Mon, 17 Jan 2022 19:59:19 +0100
Newsgroups dbase.getting-started

Hi Rouke,

> how do I do this in sql:
> str(val(trapnumber),2,0,'0')

Try this:

cVar = str(val(trapnumber),2,0,'0')

sql = [select FIELD1, FIELD2, FIELD3 from YOURTABLE where FIELD2 = '] +
cVar + [']

where sql is the SQL property of your query. Does this make sense, is
that what you're looking for?

Kind regards, Heinz