'%' in variable used in like clause (PL/SQL)

From: Remi Delon <rdelon_at_my-dejanews.com>
Date: Wed, 21 Apr 1999 23:24:22 GMT
Message-ID: <7flmn2$2ia$1@nnrp1.dejanews.com>

Hi, I'm trying to use variables to build a WHERE clause with a LIKE operator.

My problem is that puting the '%' sign in the variable doesn't seem to be working. For example, if I try something like : declare
val char(10);
res integer;
begin
val:='%';
select count(*) into res from my_table where col like val; end;

No rows are selected, even though my_table contains lots of datas ! I've noticed that if, let's say, 'col' is a 4-digit integer and I use val:='____' instead of val:='%', it's working and all rows are selected !!

Any ideas on what's going on ?

Thanks

Remi.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 21 1999 - 18:24:22 CDT