Filtering out blank spaces

Question

I want to query a table and get all rows where the column i_vhcl_recal is not empty. I ran the following below and kept getting rows that appeared to be empty. Upon inspection, that the fields weren't null but instead they were a string of blank spaces.

How to I query rows where i_vhcl_recal has an actual value and not blank spaces or nulls?

SELECT * 
FROM table 
WHERE i_vhcl_recal IS NOT NULL

Duplicate of https://stackoverflow.com/questions/41938704/how-to-match-not-null-not-empty — Kwame Opare Asiedu, Dec 16 '19 at 21:48
Does this answer your question? [How to match not null + not empty?](https://stackoverflow.com/questions/41938704/how-to-match-not-null-not-empty) — Eric Brandt, Dec 16 '19 at 21:52

score 3 · Accepted Answer · answered Dec 16 '19 at 21:46

3

Try this:

SELECT * 
FROM table 
WHERE (i_vhcl_recal <> '') IS NOT TRUE;

answered Dec 16 '19 at 21:46

Óscar López

232,561
37
312
386

score 0 · Answer 2 · answered Dec 16 '19 at 21:51

You could do this with a regex:

select * from table where i_vhcl_recal is not null and i_vhcl_recal !~ '^\s*$';

The interesting thing about '\s' is that it matches on a variety of space characters such as: carriage return, line feed, horizontal tab, vertical tab, form feed.

Filtering out blank spaces

2 Answers2