How do I filter out records that contain WHITE SPACE in a field or have this field empty?For example: select * from mytable where fld <> "" and fld LIKE .....
Do you mean "contain ONLY white space"? Are you after this? select * from mytable where trim(fld) <> "" ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------