Character Codes

[nirasha]

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

[marist89]

To me, it sounds like a perfect place for a stored procedure.