Kbase P98848: Can SQL be used to strip all non-numeric characters from a field when the contents of the field are
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/12/2004 |
|
Status: Unverified
GOAL:
Can SQL be used to strip all non-numeric characters from a field when the contents of the field are not in a standard format?
FIX:
Unfortunately the SQL language does not lend itself to doing this. There is no functionality to remove characters from a field and unless the contents of the field use a standard format SQL is not designed for this kind of manipulation.