Re: [GENERAL] How to save the results of replace(split_part(trim(both ' ' from vx6000__12channel),'__',2),'channel','myChannel') in my query into a temp variable?

2009-12-13 Thread Andy Colson
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:

[GENERAL] How to save the results of replace(split_part(trim(both ' ' from vx6000__12channel),'__',2),'channel','myChannel') in my query into a temp variable?

2009-12-12 Thread zxo102 ouyang
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