> how do I do this in sql:
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