>Hi,
>
>Is it possible to create a index of Numeric Digits only from the Character field (e.g. value in the filed is '123 Any Street Suite 456' and Index should have value only '123456')? If possible, please help.
>
>Thank you very much for any help.
>
>Bal Singh
INDEX ON PADR(Chrtran(myfield, Chrtran(myfield, "0123456789", ""), ""), 20)
You've to pad result to the max possible number of digits in the field otherwise it could be truncated.
--sb--