I have to admit that regular expressions is one of the topics I should learn more about...can someone help me out here? What I need is the numbers between the two underscores as one column and whatever is between the "jb" and the ".jpg" in another column.
How would I go about doing this...?? ->
DECLARE @table TABLE (
INSERT INTO @table
SELECT Filename, Col1 = PATINDEX('_[??]_', Filename), Col2 = PATINDEX('jb[??].jpg', Filename) FROM @table AS t
View Complete Post