Re: Informix SPL - String Functions

Nathan If you have a 7.3x server, then you can use the substr() function. HTH Sujit Nathan Lee <nathan@diggy.com.au> on 02/18/2000 02:45:33 PM Please respond to Nathan Lee <nathan@diggy.com.au> To: informix-list@iiug.org cc: Subject: Informix SPL - String Functions Hi, I am an Oracle Developer, stuck in an Informix world. I am trying to do probably the simplest thing I can think of and cannot get it to work. What I am trying to do is given a string, go through it and find the occurences (what positions in the string) another string has. My questions are..... What type of variable to I need? Varchar, lvarchar?? I do not know how long the string will be each time. Is there string funcitons in Informix (we have the crappiest documentation here) that allow you to access character by character?? I read somewhere that you cannot actually use a variable (ie a counter) when accessing some data types. ie StringName[counter] won't work. Is this true? Or is this whole line of questioning pointless?? Can anyone help?? Mark