I think my question was littble confused. Okay, following is the query that I wanted to write, select max(start_time) from fm_audit_form where ws_id = 'S'||userenv('SESSIONID') Is there any way that I can rewrite this query? Long time ago, I have read that we can rewrite queries that has concat in the where clause values. On 3/21/06, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote: > SELECT ...... FROM where COLUMN = 'SVALUE2'; > > :-) > > Quoting The Human Fly <sjaffarhussain@xxxxxxxxx>: > > > How can I rewrite the query which uses concatination in the where > > clause? For an example, > > > > SELECT ...... FROM where COLUMN = 'S'||'VALUE2'; > > > -- > regards > > Wolfgang Breitling > Oracle 7,8,8i,9i OCP DBA > Centrex Consulting Corporation > www.centrexcc.com > > -- 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." -- //www.freelists.org/webpage/oracle-l