Welcome to the Lounge

Slacker007 wrote:

John Simmons / outlaw programmer wrote:

a lot of DBA's "aren't programmers"

It has been my experience that a lot of DBAs are not DBAs.

CREATE FUNCTION justNumeric 
(
	@INP NVARCHAR(20)
)
RETURNS NVARCHAR(20)
AS
BEGIN
	RETURN substring(@INP, PATINDEX('%[0-9]%', @INP), 1+PATINDEX('%[0-9][^0-9]%', @INP+'x')-PATINDEX('%[0-9]%', @INP))
END

SELECT MIN(dbo.justNumeric(ID)), MAX(dbo.justNumeric(ID)), Fruit
FROM Fruits
GROUP BY Fruit

John Simmons / outlaw programmer wrote:

Well, I assume the question I answered was a classroom or homework assignment, so you can't blame a DBA for what was required.

John Simmons / outlaw programmer wrote:

In the interest of full disclosure, I did rant about the assignment, assignments like it, and the idiot instructors that come up with this crap, in my answer.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

SELECT 
    MIN(N.JustNumeric) AS MinID,
    MAX(N.JustNumeric) AS MaxID,
    F.[Fruit] 
FROM 
    [#fruits] As F
    CROSS APPLY ( SELECT substring(F.[ID], PATINDEX('%[0-9]%', F.[ID]), 1 + PATINDEX('%[0-9][^0-9]%', F.[ID] + 'x') - PATINDEX('%[0-9]%', F.[ID])) ) As N (JustNumeric)
GROUP BY 
    F.[Fruit]
;