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