Search for String patterns in a Database table

[Former Member]

Hi

There is a select statement using where condition with a like statement

WHERE table1  <> 'JP'
             AND (
                 ( field1 LIKE '%:%' OR field2 LIKE '%:%' ) 

It fetches records where the field field1 or field2 has string:string as value where string is some set

of characters . What is the equivalent of LIKE in se11 / se12 .

Thanks in advance .

Geethanjali

[Former Member]

Hello

In SE11/SE12 use asterisk ( * ) for field.

[Former Member]

actually my pattern requires %:% where in i have to include even the : . how do i enforce this selection ?

[Former Member]

Hello

Try

*:*

[Former Member]

Hi,

Go with above suggestions & use asterisk ( * ).

Thanks & Regards,

Krishna...