Re: "Like" problems ?

Joachim Pense schrieb:

> It would be helpful if you can post a select * from Test (after
> minimizing its contents, of course), so we can see the data.

It was just an example. The effect is for ALL my tables. Lets say,

Table Test
 {
 name varchar(20),
 age number;
 }

Andreas 25
Adam 4095
Egon 42

SELECT * FROM Test WHERE Name LIKE 'A%' will return no results.
SELECT * FROM Test WHERE Name LIKE 'A_am' will return no results.
SELECT * FROM Test WHERE Name LIKE 'A%' or Name='Adam' will return Adam.
SELECT * FROM Test WHERE Name LIKE 'A%' or Name='Egon' will return Egon.
SELECT * FROM Test WHERE Name LIKE 'A%' AND Name='Adam' will return no results.

etc..

just like i would enter a comletely senseless comparison value for LIKE.

-- 
                                              Andreas
Seeing Dune worms, i don't want to see the Dune BIRDS...