wild card filtering [message #1579] |
Tue, 14 May 2002 13:59 |
ckr
Messages: 13 Registered: May 2002
|
Junior Member |
|
|
is there any reason why wildcard filtering('_') does not work for some tables? i copied a set of tables from a book.surprisingly this _ wildcard filtering is not working only for those tables.it is working with other tables which i have created.
is there any reason for this?
|
|
|
|
Re: wild card filtering [message #1590 is a reply to message #1579] |
Wed, 15 May 2002 06:34 |
ckr
Messages: 13 Registered: May 2002
|
Junior Member |
|
|
select prod_id,prod_name from products where prod_name like'__ inch teddy bear';
this is the query and i am getting the result'no rows selected'.
prod_name is of string data type only.
it should return '18 inch teddy bear'
|
|
|
Re: wild card filtering [message #1621 is a reply to message #1590] |
Thu, 16 May 2002 05:18 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
Hmmm........<scratches head>
I don't know.
The syntax is definitely valid.
The column isn't a char is it (as opposed to a varchar2)?
Does forcing both sides of the query to upper case make a difference?
Sorry I can't be more help.
|
|
|