>>AFAIK both are incompatible. SQL server one:
>>
>>ISNULL( Member.NoSchool , 0 ) as NoSchool
>>
>>I think having first version if first value is null it's specifying the width of the field.
>
>I am not sure what you mean. Could you elaborate more on the topic?
I mean, it's first row's value that specify what the result size of field would be. If first match is a null putting 0 there fields size is 1 and say a value of 12 would show as *.
Cetin