Re: Substring selection in Stored Procedure

--Boundary_(ID_N3N5FjuoDH2tmAOehBDNnw) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Paulo There is a SUBSTR() function in 7.30 upwards. for k = 1 to 10 select substr(vllimite, k, 1) from tab1 where 1=1; end for; should work. HTH Sujit Paulo Amorim <pauloamorim@uol.com.br> on 12/29/99 11:53:04 AM Please respond to Paulo Amorim <pauloamorim@uol.com.br> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Substring selection in Stored Procedure --Boundary_(ID_N3N5FjuoDH2tmAOehBDNnw) Content-type: text/plain; charset=iso-8859-1 Content-disposition: inline Content-transfer-encoding: quoted-printable Hi Does anybody knows if there is a way of perform a substring selection inside a stored procedure ??? I=B4m sending an example above, wich is Hope somebody can help me Thanks in advance for k =3D 1 to 10 select vllimite[k] from tab1 where 1=3D1;with a syntax error, but I don=B4t know how to handle with this. I=B4m using IDS 7.31 end for -- Paulo Roberto Marelli de Amorim TS&0 Consulting Brasil Sent via Deja.com http://www.deja.com/ Before you buy. = --Boundary_(ID_N3N5FjuoDH2tmAOehBDNnw)--