Regex for RM-EC001 (in sql-server) -

I have a text and want to find all the circumstances: prefix RM-EC + 3 digit number . For example RM-EC001 , RM-EC099 or RM-EC100

Try this:

  rm \ -EC \ d {3}  

As you are using SQL Server, I have just come to know that you can not use Quantifier: Log in # test value ('rm-cc 001') # test value ('rm - EC099 ') #Test VALUES (' RM-EC100 ') INSTERT # Enter the test value (' RM-ECAM 99 ') SELECT * FROM #test Where value' RM-EC [0- 9] [0-9] ] [0-9] ''