Specify expression in LIKE operator

Question

How can specify expression in LIKE operator

I want to select all row in table where column Name starts with a-zA-Z followed by # and does not have two dots together (..)

i tries this WHERE NAME LIKE '%[a-zA-Z]#'

Answer 1

WHERE name LIKE '[a-zA-Z]#%' AND NOT (name LIKE '%..%')

Answer 2

WHERE Name LIKE '[A-Za-z]#%'
    AND Name NOT LIKE '%..%'