WILD CARDS IN SQL SERVER

select productnumber, listprice from sales where productnumber like 'BR-_[0-9][0-9]_-[0-9][0-9]'


BR-_[0-9][0-9]_-[0-9][0-9]
Starts with BR
dash
any character
number, number
any character
dash
number, number