Character subscripts in SQL/SPL

Posted in 1997

Jeff Larsen — Thu, 28 Aug 1997 13:04:33 -0500 — source: Informix-list mailing list archive (1991-1998)

Since you can't use variables for character subscripts in SQL or stored procedures, how do you do any useful string manipulation? I am trying to write a stored procedure to calculate the soundex value of a character string. It's going to get ugly if I can't loop through the characters. Is SQL really this lame? -------------------------------------------------------------------- Jeff Larsen Quicksilver Express Courier, Inc. larsen@qec.com (612) 484-1111