How to check if a BLOB is null

you will need to convert to text and then do a check.  

if isnull(totext(field)) then 'Nothing Here' else totext(field)

WHy the need to convert it to text
ALso CR8.5 cannot return more than 254 characters from the formula so converting the blob to text is likely to cause an error of string too log.

What do you want displayed if the field is NULL?

To test if it is NULL you should be able to simply use

   IsNull({YourBlobField})

mlmcc

A bad habit of mine to convert blog and memos to text first.  Thanks for the heads up on the CR8.5 limit.

mlmcc:

where do u add the isnull() bit?

i m only using the crystal 8.5, i tryed adding it o tthe sql statement but it desapears ?

it worked for me in teh supression formula cheers