character codes

hello,

I have a table CAT and a field called name.

I want to search in all the values of cat and obtain the distinct list of character codes that field contains, eg:

table chair desk

would return the character codes for (t,a,b,l,e,c,h,i,r,d,s,k)

Thanks in advance
Nirasha

Check the oracle text, in the technet for the functionality. Past three issues of oracle magazine has an articl on oracle text, I beleive.

Good luck
Sam