SQL Server : select statement where value have format

Question

I'm trying to find special string that has a format like ##-%, start from two character and '-'

select * 
from temp 
where name like '##-%'

Give me some advice, or example how I can get this?

And how can I replace this format on empty string ""

Answer 1

If would you find the special character which is start from two character and '-'

select * from temp where name like '[a-z][a-z]-%'

if would you want to find the special string have format like '##-%

select * from temp where name like '##-[%]%'

If would you want to find the third letter is '-'

select * from temp where name like '__-%'