db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicolas Dufour <nicolas.duf...@neometsys.fr>
Subject Tests in SQL
Date Fri, 30 Sep 2005 18:49:28 GMT

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 ?



View raw message