y not just do
SELECT *
FROM testdb
...
The `%` will not match NULL values.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/3/04, 9:41:22 AM, "Jonas Lindén" <[EMAIL
If you want all values why not just do
SELECT *
FROM testdb
...
The `%` will not match NULL values.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/3/04, 9:41:22 AM, "Jona
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> SELECT * FROM testdb WHERE col1 LIKE '%'
>
> The above SELECT statement doesnt return columns with NULL values. Should it? ;).
Yes. % matches any number of characters, NULL is not character string. Use IS NULL or
IS NOT NULL operators if you want to test
seems like gotcha :))
use:
SELECT * FROM testdb WHERE col1 LIKE '%' OR col1 IS NULL;
On Wednesday 03 of March 2004 16:41, Jonas Lindén wrote:
> Hello list
>
> SELECT * FROM testdb WHERE col1 LIKE '%'
>
> The above SELECT statement doesnt return columns with NULL values. Should
> it? ;). Should I
Hello list
SELECT * FROM testdb WHERE col1 LIKE '%'
The above SELECT statement doesnt return columns with NULL values. Should it? ;).
Should I approce the problem in another direction?
Regards
/Jonas