Get rows with more then a word with SQL Server

Question

How do I get all the rows of a table that have one word, and the ones that have more then a word:

For example take the following records:

CARROCARIA PINTURA
VEICULOS ALUGUER
VEICULOS ELETRICOS
SERVICOS RAPIDOS
VEICULOS COMERCIAIS
ELETRICIDADE
VIDROS

I get with query 1:

ELETRICIDADE
VIDROS

I get with Query 2:

CARROCARIA PINTURA
VEICULOS ALUGUER
VEICULOS ELETRICOS
SERVICOS RAPIDOS
VEICULOS COMERCIAIS

Thanks.

But **ELETRICIDADE VIDROS** if is a one row, then have two words...i do not undestand. — Gaston Flores, Jul 13 '13 at 18:44

Ian Kenney · Accepted Answer · 2013-07-13T19:15:42.673

5

One word

select * from tablename where fieldname not like '% %'

multiple words

select * from tablename where fieldname like '% %'

EDIT

if leading / trailing spaces could be an issue, you can use something like

select * from tablename where ltrim(rtrim(fieldname)) like '% %'

edited Jul 13 '13 at 19:15

answered Jul 13 '13 at 18:43

Ian Kenney

Beware trailing/leading spaces – nathan_jr Jul 13 '13 at 19:12
Maybe you can help me on this one: http://stackoverflow.com/questions/17634090/create-related-records-based-on-string-in-sql-server – Patrick Jul 13 '13 at 20:47

1 Answers1