On 12/12/2009 09:59 AM, zxo102 ouyang wrote:
Hi everyone,
I have a big query (see below attached) in which all where clauses
have sc.channel = replace(split_part(trim(both ' ' from
ec.instantance_flux),'__',2),'channel','myChannel').
The value of ec.instantance_flux is like the format:
Hi everyone,
I have a big query (see below attached) in which all where clauses have
sc.channel = replace(split_part(trim(both ' ' from
ec.instantance_flux),'__',2),'channel','myChannel').
The value of ec.instantance_flux is like the format: vx6000__12channel. I
want to replace channel with