First, what are you hoping to accomplish by rewriting it?  Is there an index on 'COLUMN' that is not being used because of the expression in the WHERE clause?  Is there another factor that you are trying to address?

=====================================

Jim Silverman

Senior Systems Database Administrator

Solucient, LLC

Telephone:   734-669-7641

FAX:            734-930-7611

E-Mail:         jsilverman@solucient.com

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of The Human Fly
Sent: Tuesday, March 21, 2006 10:10 AM
To: oracle-l
Subject: tuning query with concat string.

Hello list,

How can I rewrite the query which uses concatenation in the where clause? For an example,

SELECT ...... FROM where COLUMN = 'S'||'VALUE2';

Thanks for your time.

--

Best Regards,

Syed Jaffar Hussain

8i,9i & 10g, OCP DBA

Banque Saudi Fransi,

Saudi Arabia

http://jaffardba.blogspot.com/

----------------------------------------------------------------------------------

"Winners don't do different things. They do things differently."

--

http://www.freelists.org/webpage/oracle-l