topic LIKE in a SELECT statement in Application Development and Automation Discussions

LIKE in a SELECT statement

Former Member — Tue, 11 Mar 2008 16:24:46 GMT

Is it possible to use LIKE keyword in a SELECT statement more than once? If not, is there any alternate way of doing this? I am not getting anything returned when I use it twice on the same field.

I have a table CDPOS with field TABKEY which is 70 CHAR long.

Value of field TABKEY in table CDPOS = '00003001001PR00'

LINEITEM = '000030%'

CONDITION = 'PR00%'

I used the following select statement to retrieve the above CDPOS value..

select objectid changenr from cdpos into table tmp_cdpos

where tabkey like LINEITEM and tabkey like CONDITION.

If I use just 'lineitem' with the LIKE, it works but adding 'tabkey' results in no hits.

Re: LIKE in a SELECT statement

Former Member — Tue, 11 Mar 2008 16:33:47 GMT

Use OR instead of AND in the select statement then it works.

select objectid changenr from cdpos into table tmp_cdpos

where tabkey like LINEITEM

OR tabkey like CONDITION.

Thanks

Srinivas

Re: LIKE in a SELECT statement

Former Member — Tue, 11 Mar 2008 16:34:06 GMT

change CONDITION = 'PR00%'

to CONDITION = '%PR00'

The % represents the variable portion of the condition.

Re: LIKE in a SELECT statement

Former Member — Tue, 11 Mar 2008 16:38:47 GMT

Try:

SELECT * FROM cdpos
  WHERE tabkey LIKE '000030_____PR00%'.    <== Underscores

Rob

Re: LIKE in a SELECT statement

Former Member — Tue, 11 Mar 2008 16:49:50 GMT

Thank You, Rob. Your solution worked.

Anjana