If IsNull Always Returns Alternate Text 1

[mabis]

CRM program running on SQL2000. Attempting to evaluate contact titles that are null. In SQL title field is datatype=picklist, size 64, nulls allowed.

In all cases my formula returns "No Title" when sql query verifies some title fields are populated.

if isnull({CONTACT.TITLE}) or InStr({CONTACT.TITLE}, " ") = 0 then "No Title" else ({CONTACT.TITLE})

Any help is appreciated. My google efforts dont go further than the formula above.

 

[synapsevampire]

Try:

if isnull({CONTACT.TITLE})
or
trim({CONTACT.TITLE}) = "" then
"No Title"
else
{CONTACT.TITLE}

-k

 

[mabis]

Thank you for your quick and accurate reply. This works as I hoped and intended.

Mabis

 

[nathj]

Hi,
I have similar problem when using IsNull in Crystal

If IsNull(Count({tmpChild.FFCHILD})) OR Count({tmpChild.FFCHILD}) = 0 then
SuppressChild:= TRUE
Else
SuppressChild:= FALSE;

The value in tmpchild.FFChild is 20.00. However, IsNull(Count({tmpChild.FFCHILD})) returns True as does IsNull({tmpChild.FFCHILD}).

Any ideas as to how to make this work correctly would be much apprecited.

Many thanks
Nathan Davies