half a pound of mashed potatoes???I would be asleep for a full day. I opt for salad. i.m a healthy 12.5 stone (I dropped to 9 stone at one...

low carb diet? - I eat bread or fries once a week. It makes me sleepy.

I found that a lot of veg and chicken is a good...

low carb diet? - I eat bread or fries once a week. It makes me sleepy.

I found that a lot of veg and chicken is a good way to...

LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.

Now my FIL, I'm...

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 6 years, 3 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...