[Info-Ingres] String Manipulations

[Roy Hann]

"Puneet Bagoria" <puneet138 at gmail.com> wrote in message 
news:mailman.372.1173948097.13098.info-ingres at kettleriverconsulting.com...
> Hi ,
>
> I have data in table column like this 1-2-3 .. I need to manipulate this 
> string and
> make a new format something like this A>B>C(A,B,C are the values present 
> in
> different table,these will be retrieved querying the table using the 
> values 1,2,3)
>
> Can any one please provide any workaround to manipulate strings while 
> using
> SQL test.

I'm not at all clear what you want to do, but possibly a CASE expression 
will help you?  Read about it in the manual and if it doesn't do what you 
want give us a bit more to work with.  It would be useful to see as much of 
your query as you already have, and maybe some sample data and at least a 
mock-up of the desired result.

Roy