For someone here to help, you need to post a more complete description of what you want to do. Keep in mind that we know only what you post about your table definition, your data, or your requirement.
I suspect that you want to retrieve a substring. . . .
Are you using spufi or are you working in some program?
Hope this helps,