RE: Parse String in Stored Procedure

You can try this: WHILE i < 8 IF old_txt[i]='-' THEN LET new_txt = old_txt[1,i-1] || old_txt[i+1, 8]; LET i = 9 ELSE LET i = i + 1; END IF; END WHILE; -----Original Message----- From: Cook, Russell L [mailto:Russell.Cook@marconi-is.com] Sent: Tuesday, August 31, 1999 6:28 PM To: 'informix-list@iiug.org' Subject: Parse String in Stored Procedure I need to create a stored procedure that parses an 8-character string, and determine if a dash (-) characters exist in this string. If a dash character exist in the string, I would like to delete it. Anyone have an experience do this or an example. Appreciate all of your help. Thanks in advance. Russ Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc