Yuriy Martsynovskyy<[EMAIL PROTECTED]> wrote:
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 .....
fld <> '' and not (fld LIKE '% %') -- that's percent space percent Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
