Extract subString from a string - Pattern Matching

Question

Hi,

I am searching a pattern with the following one and i would like to extract only the string which is in the format([0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]).

SELECT [Source-LineDescription]
FROM [FAR_March2012_SourceLines]
WHERE [Source-LineDescription] like '%[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]%'

Thanks.

 

Answer 1

SELECT [Source-LineDescription],
	SUBSTRING([Source-LineDescription],PATINDEX ('%[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]%',[Source-LineDescription]),10)
 FROM [FAR_March2012_SourceLines]
 WHERE [Source-LineDescription] like '%[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]%' 

Something like this

---

Chuck

Answer 2

Thanks. Works for Me.

Answer 3

Try this:

DECLARE @x nvarchar(MAX) = N'This is a string with numeric pattern in it: 123-00-123. More text follows!'
SELECT substring(@x, patindex('%[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]%', @x), 10)

---

Erland Sommarskog, SQL Server MVP, [e-mail]