Finding strings with embedded spaces in a column

Question

I have to find a way to figure out the values with embedded spaces in a column. Example :

Table : Test

COLUMN

ABC       -- OK

A B C     -- OK (only one space between word)

A  B  C   -- (fetch this)(2 spaces)

A   B   C -- (fetch this)(3 spaces)

As the last 2 values in the column having embedded spaces, somehow I have to fetch these values..

Any suggestion...

Gordon Linoff · Accepted Answer · 2014-07-09 02:58:40Z

1

Is this what you want?

select *
from test t
where column like '%  %';

Note there are two spaces between the wildcards.

answered Jul 9, 2014 at 2:58

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Finding strings with embedded spaces in a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related