topic Re: Search for String patterns in a Database table in Application Development and Automation Discussions

Search for String patterns in a Database table

Former Member — Fri, 12 Dec 2008 06:52:40 GMT

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 — Fri, 12 Dec 2008 06:58:52 GMT

Hello

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

Former Member — Fri, 12 Dec 2008 08:21:06 GMT

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

Former Member — Fri, 12 Dec 2008 08:38:56 GMT

Hello

Try

*:*

Former Member — Fri, 12 Dec 2008 13:18:14 GMT

Hi,

Go with above suggestions & use asterisk ( * ).

Thanks & Regards,

Krishna...