I want to write the query to get the assigned number for the key.

All the keys(100 keys) are stored in one field with the comma separated.

**************Keys Sample******************************

klwhentyq - 1,hqjsuhruy - 2,kmjhsfrgt - 3,ktlnxgsdt - 4,

*******************************************************

table name is cal and field name is key.

could you please tell me how i can get just the number:

select key from cal where key like = klwhentyq;

i want to get one for the above condition.

Thank you very much.