How to handle wild card character in like search query?

Question

User-1148373670 posted

Hi,

I am using LIKE search query in oracle.

in search value putting _,% its return all the records.

for example:

string val1=_

and putting value returns all the records except val1 not start with _.

Hoe to handle this.

Pls help me

Thnaks in advance

Answer 1

User-1768369891 posted

hi try this.

http://forums.asp.net/t/1729881.aspx/1?Match+keyword

Answer 2

User-1148373670 posted

hi try this.

http://forums.asp.net/t/1729881.aspx/1?Match+keyword

Thanks for support.

But my problem is 

i am searching record based on wild character(_,%) but records are not start with thease character and rerurning the records

Answer 3

User-1768369891 posted

hi check this..

http://www.techonthenet.com/sql/like.php

http://psoug.org/reference/wildcards.html

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/conditions007.htm

http://www.devx.com/tips/Tip/31135

http://jeffkemponoracle.com/2008/07/14/prefix-searches-wildcard-characters-and-like/

Use this

Answer 4

User269602965 posted

post your SQL code.

Show better example of what data you are trying to return.