SQL - Need help build a select query

Question

Hi

I've a table (hosted in a database SQL Server) where i've products stored. The person who inserted a few products last week, instead of making new lines with "Enter" (tinyMCE would created a </br> tag) in description, she had typed "Space" creating white spaces (she though that typing white spaces, creates new line when it goes to the new line. Really dumb).

So, i've records something like this:

Description:       &nbsp   &nbsp   &nbsp   &nbsp   &nbsp    

Now i'm trying to create a query for search this records, but i think i'm using LIKE operator in a wrong way.

SELECT * From ProductsDescription WHERE Description LIKE '%  '

It's returning 0 rows. Is anything wrong in that query?

Thanks

Answer 1

Try adding another percentage sign at the end as well, in case the last character isn't a semi-colon, i.e:

SELECT * From ProductsDescription WHERE Description LIKE '%  %'

Answer 2

1. Get rid of the spaces inside the single-quotes.
2. Append another %.

E.g.:

SELECT * From ProductsDescription WHERE Description LIKE '%  %';

Edit:
Ignore point #1 above. As @Hippo notes in a comment that was simply a formatting issue. I have edited the question to remove the extraneous spaces.

Answer 3

select * from ProductsDescription where description like '%nbsp%'

Answer 4

Here's a similar question - have you reviewed this answer yet?

http://stackoverflow.com/questions/457701/best-way-to-strip-html-tags-from-a-string-in-sql-server