Converting Access to TSQL

SQL Server Administration
1

Hi experts,
I'm struggling with converting some Access code to TSQL. I've done some digging but didn't find anything I trust.

In Access Replace([Column1],"aaa #","") equals what in TSQL?

WHERE Column2 Like "star aaa #star") is something like LIKE '%aaa%' but what would the # be in TSQL? (The website editor eliminates the * so I entered it as a word)

Thanks,

2

It would be LIKE '%aaa[0-9]%'

[ ] Wildcard to match characters - SQL Server (Transact-SQL) | Microsoft Docs

PATINDEX (Transact-SQL) - SQL Server | Microsoft Docs