NULL is handled like "unknow"
When you comparing something with an unknown value,
you are not able to say if they are equal or not.
So the result is also unknown.
The result NULL is correct.
If you whant to check if somethings is NULL
you have to use "(anything) IS NULL"
Rich Hall schrieb:
My ques
I could not found an other quoting.
This quoting us annoying me also.
I would be nice to have an additional simpler quoting
in one of the next versions.
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. Juni 2004 07:12
To: [EMAIL PROTECTE
create temporary table tmp_foo AS select * from foo;
Geoff Richards schrieb:
Hi,
I've got some code that currently uses MySQL, and it copies an existing
table into a temporary one like so:
create temporary table tmp_foo select * from foo;
That creates 'tmp_foo' with the same columns as 'foo', wh
select
( select a from t1 where CAST(t1.oid AS int) - CAST( (select min(oid) from t1) AS
int ) = t_all.rownum ) AS a
, ( select b from t1 where CAST(t1.oid AS int) - CAST( (select min(oid) from t1) AS
int ) = t_all.rownum ) AS a
, ( select c from t2 where CAST(t2.oid AS int) - CAST( (select min
One solution:
select replace( replace( replace( replace( 'Test ä ö ü ß', 'ä','ae'), 'ö','oe' ),
'ü','ue'), 'ß','ss' );
replace
--
Test ae oe ue ss
If you also have upcase-characters, you have to extend the statement.
Robert Strötgen schrieb:
I want to query words with German
