I got the question wrong yesterday because I chose the option that was incorrectly marked as unsupported.  Now that option's been replaced, I've got the question wrong because I apparently...

we just got graded on a scale of risk

but for those of us that are level 2 or higher (children or wife at risk) (0=you will die)  but we...

or she would create a new account...

Do you mean Clinical Data Capture or Change Data Capture?

I remembered coming across this article once upon a time which lead me here.  If I recall correctly I was fighting with a similar sort of thing in...

I threw out all my Dan Brown books too so I was doubly sure.

Thank you, sorry for being an annoying noob moron, will try to do better in the future with well-formed requests.  This is very helpful, I have been stuck for...

Without wanting to pile-on, there's no 31st of September either and there's a Sale Date in your Desired Results picture that's not in Table 1.

You'll generally find most people around...

• This reply was modified 5 years, 10 months ago by Neil Burton.

select 
LEFT(filename,LEN(filename)-CHARINDEX('\',REVERSE(filename)))
from master..sysaltfiles

That should do it.

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...

From the post:

Not sure where this is useful or why it's there, but if anyone uses this, let us know.

If you yabingle "quirky update", you'll find examples of...

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 5 years, 10 months ago by Neil Burton.
• This reply was modified 5 years, 10 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...