Does firebird support the replacing of null values with a user specified
value in the select clause?



Example:



Select R.rdb$field_position As Column_Pos,

R.rdb$field_name As Column_Name,

T.rdb$type_name As Data_Type,

F.rdb$field_length As Column_Length,



Null(R.rdb$null_flag,0) As Is_Nullable, /*<----------------
Example */



From rdb$relation_fields R,

rdb$types T,

rdb$fields F

Where R.rdb$relation_name = 'CUSTOMER'

And F.rdb$field_name = R.rdb$field_source

And T.rdb$field_name = 'RDB$FIELD_TYPE'

And F.rdb$field_type = T.rdb$type

Order by R.rdb$field_position



Thanks


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004



[Non-text portions of this message have been removed]