Can 'Like' can have a VARIABLE value

ap_mainframes · Posted: Mon Mar 16, 2009 8:10 am

Hi,

I have got a requirement where I need to use Like clause.
but this Like can have a VARIABLE value.
Example,

It can have value as 00349 or 00550 or any other value.

How do I retrieve this from database ?

Please advise.

dick scherrer · Posted: Mon Mar 16, 2009 8:30 am

Hello,

Not sure how this fits LIKE. . .

Probably i misunderstand, but why not use the values with OR's?

Terry Heinze · Posted: Mon Mar 16, 2009 9:00 am

or IN.

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Hi ap_mainframes,
If you are uncertain about what you are going to retrieve then it is better to fetch all the datas without any condition.

Succor · Posted: Mon Mar 16, 2009 1:35 pm

ap_mainframes,
If this is a cobol DB2 program then you can make use of the host varibales without 'LIKE'.
If you are aware of only part of the varibale field then you may try using LIKE in the following manner:
Assuming the field length be Char(08)...then for 00349... you serach with
LIKE '00349%%%' ...for 00550 ..LIKE '00550%%%' ...and so on ,keep moving the part of the field in to the variable.

WTF

tarun_bhardwaj · New User Joined: 18 Jul 2003 Posts: 39 Location: delhi

You can use a host variable to achieve this. We have this running in our shop.

rajesh_mbt · New User Joined: 27 Mar 2006 Posts: 97 Location: India