Using pattern search in SQL Server Query

Question

Is it possible to use following pattern in the Query to get the below results?

1.To get all the employee details where Employee number is 8 digits with starting letter as K and rest as integers

Eg: K1234567

SELECT * 
FROM EMPLOYEE 
WHERE EMP_NO LIKE '[K\d{7}]'

PS: I did not get the desired result by running the query, please suggest if there is anything wrong here.

Martin Smith · Accepted Answer · 2013-08-11 14:33:40Z

2

Yes this is possible with the pattern below

SELECT *
FROM   EMPLOYEE
WHERE  EMP_NO LIKE 'K' + REPLICATE('[0-9]',7)

answered Aug 11, 2013 at 14:33

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1