>Hi,
>
>I have two fields, and their values type are string and .NULL.
>how i can make one string from these values. (new_var = string + .NULL.)
>
>Thanks
I would use
new_var = string + nvl(String_That_Might_Be_Null, "???").
If the second part is not null, it will be copied as is. If it is null, "???" (which many a user will understand as "unknown value") will be replaced.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)