SQL: select when a character occurs more than once in a column

Question

I have a select statement

select * from B2B_CardTechCards
        where Field NOT LIKE '%-%'

I only want to select cells that have more than one occurrence of "-". if this happened, when I do not need it.

Answer 1

Just search for two of them:

select * from B2B_CardTechCards
where Field LIKE '%-%-%'

Answer 2

You can find the counter '-'in the column Fieldusing

(len(Field) - len(replace(Field, '-', '')))

Now we can select rows with the above account value of more than one

select * 
from B2B_CardTechCards
where  (len(Field) - len(replace(Field, '-', ''))) > 1