After you find the record, you can use STREXTRACT() function.
lcKeys = "klwhentyq - 1,hqjsuhruy - 2,kmjhsfrgt - 3,ktlnxgsdt - 4," + ","
lcCurrKey = "klwhentyq"
? STREXTRACT(lcKeys, lcCurrKey + " - ", ",")
>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.
--sb--