These only strip lines with Space characters. I need also to filter
out also tabs, carriage returns and all series characters that
constitute a white space.
-
To unsubscribe, send email to [EMAIL PROTECTED]
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) <> ""
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 .
-
To unsubscribe, send email to [EMAIL PROTECTED]
3 matches
Mail list logo