I have a table that has an column id of the form D1,D2,D3...
I want to select the rows based on:
SELECT * FROM "SAP_ECC"."PARSONSF"."VBRP"
WHERE "VBELN" >= 'D10' AND "VBELN" <= 'D100'
to retrieve D1,D2,D3,D4...D100
But I only get D1,D10,D100.
Any ideas how I can do this?