DECLARE 
@String VARCHAR(100) = 'CKflower2002-pouch-5AR-OneSize'
select 
SUBSTRING(@string,PATINDEX('%[0-9]%',@string),PATINDEX('%[^0-9a-z]%',@string)-PATINDEX('%[0-9]%',@string))

That will work for whatever the first delimiter is and for any length of string before the numbers.  It does assume that...

• This reply was modified 6 years, 3 months ago by Neil Burton.
• This reply was modified 6 years, 3 months ago by Neil Burton.

select REPLACE(REPLACE(SUBSTRING('CKnovelty2002_pouch-5AR-OneSize',1,CHARINDEX('_','CKnovelty2002_pouch-5AR-OneSize',1) - 1),'CKnovelty',''),'CKflower','')

Your CHARINDEX was looking for '-' rather than '_'.

don't - I went once and it was "an experience" (this is from Wikipedia)

Kæstur hákarl, fermented Greenland shark.

Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled...

The end of last month was fantastic because I had a week in...

You need to run

EXEC sp_rename

and remove the ''GO'.  That is a batch separator so your IF is technically in a different piece of code from your ELSE.

If I remember rightly it's something to do with execution plans that use temp tables but don't take my word for that.

This post helped me in a similar situation.  There might be a couple of other things you need to do but that was a good place to start.

Sometimes a loop is the best way to do something.  Doing something iteratively can be one of those times.  Have you tested the performance of a loop? Do you know...

Stopped gigging a while back, now it is only for my personal pleasure (read: when no one else is at home)

Same here, it's one of the disadvantages to the 9-5...

Some of the special Jacks are much better.  I don't think they're...

OK, so I'm curious and interested in expanding my repertoire when it comes to liquor...

Whiskey / whisky vs scotch, and, what's so bad about Jack D?

(Note, I've only...

Haggis is great though! Haven't had it in ages mind, but I've enjoyed it every time I have. In...

Careful with that 'e' there Mike.  It's normally 'whisky' you have with haggis.

I'm planning on doing another belly this summer when I do 2 pork shoulders and 6 chickens for my daughter's grad party.  She's undecided on the smoked macaroni and cheese. ...

The one time I met Grant in person, we chatted about...