RE:Strange result using: select and the '=' sign?

When making a selection using :

SELECT * FROM tableName WHERE tableCol = '1234'

It won't return anyting. (The tableCol is of the VARCHAR2 type)

The following works:

SELECT * FROM tableName WHERE tableCol = TO_CHAR(1234)

SELECT * FROM tableName WHERE tableCol >= '1234'

SELECT * FROM tableName WHERE tableCol <= '1234'

SELECT * FROM tableName WHERE tableCol BETWEEN '1234' AND '1234'

And also the way that I have solved the problem with att the moment:

SELECT * FROM tableName WHERE tableCol >= '1234' AND tableCol<='1234'

Have I made a fatal misstake, is it a bug or???

christer.wallentin_at_notes.sema.se Received on Wed Mar 22 2000 - 07:51:02 CST