Need to narrow down data from a table which matches certain pattern.

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Hendricks Ten Centuries Points: 1006 More actions · Answer 1

Ten Centuries

Points: 1006

April 19, 2016 at 4:25 pm

select *

from Audit

where detail like '%2%[0-9]%'

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 2

If you want it to be exactly a two, preceded by a comma, followed by a comma, followed by a number, then you'll want something like this:

CREATE TABLE #strings (some_string varchar(max));

INSERT INTO #strings VALUES

('blah blah, something,2,something'),

('more blah, some bleh,2,3,hmmm?'),

('What''s all this? Let''s count down by two, 8,6,4,2,0!'),

('This isn''t a string, that I would 2 like to have returned 8!');

--If you mean what you said about the numbers 1 through 9

SELECT *

FROM #strings

WHERE some_string LIKE '%,2,[1-9]%';

--Or if you actually mean ANY number, as you said later

SELECT *

FROM #strings

WHERE some_string LIKE '%,2,[0-9]%';

--I don't think the other provided option

-- will work for your requirements

--since it doesn't care about the commas

SELECT *

FROM #strings

WHERE some_string LIKE '%2%[0-9]%';

DROP TABLE #strings;

Cheers!

krishnamurali2489 Mr or Mrs. 500 Points: 517 More actions · Answer 3

Hi Jacob & Steve,

Thanks very much for providing easy solution to my problem.

That solved my problem and i got what i wanted.

Thanks Again 🙂

bgrossnickle Ten Centuries Points: 1332 More actions · Answer 4

Ten Centuries

Points: 1332

April 19, 2016 at 10:13 pm

test