db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suavi Ali Demir <dem...@yahoo.com>
Subject Re: Tests in SQL
Date Fri, 30 Sep 2005 19:06:00 GMT
SELECT    CASE WHEN COL1 is NULL THEN 0 ELSE 1 END    FROM MYTABLE
 
Regards,
Ali

Nicolas Dufour <nicolas.dufour@neometsys.fr> wrote:
Hello

I try to put tests in select clause.
I mean I have a field which can be null and I want to create a select 
which return 0 when the field is null and 1 in the other case.
Is it possible to do that in Derby ?
I try also to look in a string and if i recognize a pattern extract two 
parts of it and if not just take the all value.
How can i do that ?

Thanks

Nicolas


Mime
View raw message