I am selecting from a table, and want to check wheter a string begins with "1" or "2"

Can i do that?

.....
where :1 in ("1", "2")
wherebind(1, tablefield(1;1))
.....

I think one can assume that characters 1,2 are next to eachother in any sorting sequence. So with traditional programming:

set.min(comparefieldmin)
set.max(comparefieldmax)
comparefieldmin(1;1) = "1"
comparefieldmax(1;1) = "2"

Evaluation while reading:
field >= comparefieldmin and field <= comparefieldmax

tmp.string = table.field(1;1)

if tmp.string = "1" or tmp.string = "2"


i think this is the simplest way to achiev this

tmp.string = table.field(1;1)

if tmp.string = "1" or tmp.string = "2"


i think this is the simplest way to achiev this

Maybe the simpliest but sure not the more performant way :) .
In this case, the select gets all the records, and after records are used or not.
In my solution, records are chosed or not in the query directly.