You could start by using (SLEN()) to get the length of the string, then within a while loop looking for that many iterations, test each character in turn by using (SGET()) to extract the character, test it using (ISALPHA()), then, if it is alpha, append it to a result string. I'm sure you could even find ways to nest some of those functions.
Need more?
Hey everyone,
Is there a way to remove all numbers from a text string?
IE if i have a string like "34hello65748world" stored in a column I'm trying to get "helloworld".
is there a way to do that in a select statement?
Thank you!
Alan
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
