Pattern Matching in Transformation from Oracle

• ZenDada

  SSCarpal Tunnel

  Points: 4637

  More actions

  October 14, 2004 at 9:49 am

  #162840

  I have a transformation bringing stuff from Oracle to my SQL Server.  I need to use pattern matching in my query.

  In T-SQL I can write:

  Select * from MyTable where MyField like '__[rl]%'

  and the [] works fine.  But Oracle doesn't have clue what to do with [] even though it recognizes '_' and '%'.

  Can anyone show me an example of the Oracle 8i version of this query for my transformation?

  [font="Courier New"]ZenDada[/font]

• jaykumars

  SSC Veteran

  Points: 238

  More actions

  October 15, 2004 at 2:55 pm

  #526961

  I guess in Oracle 10G this feature is available.

  For  8i you have to use something like

   

  Select * from MyTable where MyField like '__r%' or MyField like  '__l%'