Re: Please can you tell me what function get a piece of text from another text?

Manuel Gallego Huertas wrote: > > Please help me. > > I am informix user from an Spanish library that use an application under > informix. > I know SQL because I was working with ORACLE and I would like to make > some masive update to my database using UPDATE command the problem is > that I don't know what is the function to get a piece of text from > another text. I know SQL because I know PL/SQL from ORACLE RDBS (INSTR > function). > Please help me and tell me what is the function I am looking for. > > Thanks in Advance. > > Please if you have a reference guide of SQL of informix please send me > to: cc0gahum@lucano.uco.es like attachment. > > Thanks again. Hi, if I got this right, you want to extract some text on basis of comparing two strings. You can use something like this: "select * from some_table where string1 matches "*some_text*" You can use any wildcards (?,*) in here. Or, try this: select * from some_table where string1[3,7] = "some_text" Also, try combining this two ways, e.g. Where string1 [3,7] matches "s?me_te*" Excuse my English, Andrej.