select statement

hi,

in the select option, the value to be entered is partly the size of the value in the field. for example BXGF0123456789PPX. user enter in the select option is 0123456789. may i know how in the select statement i can write.

user enter in select option s_fieldA is 0123456789 whereas in table this field is stored as BXGF0123456789PPX.

can i write like this?

select fieldA where fieldA+3(10) in s_fieldA

thanks