Subject Re: converting text to value in SQL From Heinz Kesting <Nobody@Nowhere.com> 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