Very Computer

I have a simple SELECT statement with two input variables, e.g., "SELECT
FROM OURTABLE WHERE ZIP3=:zip3 AND LASTNAME LIKE :surname"

I bind this two variables to input data targets (of the appropriate length)
and execute the statement.  I get no rows back.  If I hard code the
statement with the SAME data, e.g., SELECT FROM OURTABLE WHERE ZIP3=731 AND
LASTNAME LIKE 'LAB%'" (that's a single quote, then a double quote), then I
get 400 rows back.

I know the bind is working because I can see the bind data in the TRACE
file.

I've been fighting this for two days, and I'm going crazy (crazier?)  Any
ideas gratefully accepted.

Rog

--

Oops, forgot  to mention, Oracle 8.03 on NT.

Rog,
What are your bind datatypes? I'm pretty sure :surname is a SQLT_CHR
but what is :zip3?  With the SQLT_CHR you must specify the correct
size of the host variable for the comparison to be correct - this
should not include any null bytes if they are present in your host
variable being bound.

Jagdish

Jagdish,

The bind datatypes and lengths are (were) correct.  I fixed this by filling
the field (to the correct length) with '_'  (underline), rather than using
'%'

Thanks for your suggestion; it caused me to look at the problem differently.

Rog