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 the cells that has more than one occurrence of "-" in it. if it occurred once I don't need it.

Answer 1

Simply search for two of them:

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

Answer 2

You can find the count of '-' in Field column by using

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

Now we can select rows that has the above count value more than one

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