Home » Developer & Programmer » Forms » use like operator with if condition
use like operator with if condition [message #575075] Sat, 19 January 2013 00:18 Go to next message
laxminath
Messages: 14
Registered: March 2012
Location: calcutta
Junior Member
dear sir

i want to know that how can i use like operator with if condition. i m using oracle10g form builder and it's for search purpose .please help me use sir.

for example ...
if search string=string2 then

message('Record found');

end if ;

i want to use like '%search string%'.

thanx
Re: use like operator with if condition [message #575111 is a reply to message #575075] Sat, 19 January 2013 11:05 Go to previous message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Suppose that your string is 'OraFAQ Oracle forum' and you want to know whether it is like 'Oracle'; then you'd
if instr('OraFAQ Oracle forum', 'Oracle') > 0 then
   ...
end if;
Previous Topic: Data Retrieval
Next Topic: call a block from another form
Goto Forum:
  


Current Time: Thu Apr 17 03:09:58 CDT 2014

Total time taken to generate the page: 0.05408 seconds