This was definitely wrong on many levels, but what strikes me is that they are expecting to extract a time from the first 8 characters of a variable called StartDate....

Thanks guys, just the info I was missing. Much appreciated.

Thanks Alan, it's always fun to learn faster ways to do things, even if it's not something I expect to be using 🙂

While my SQL programming skills are generally sufficient...

Setting the length to 4000 isn't fool proof, because some fool may have a longer line.

I agree with others, and would not be using this solution, but if I had...

First, thank you for an introduction to a command I've never heard of. I'll need to read up on it to see if it has an application for us.

But the...

I've never use Collate and don't know what it does.

I figured the answer would be 5. Like 5 letters excluding the upper case, would leave the 5 lower case.

Not seeing...

What's the reasoning behind using the IF... GOTO Next; instead of using a Case statement?

I'm assuming the Case would execute faster, but regardless, I think it would be easier to...

Wrong here. Probably because I don't know anything about table variables, or try/catch for that matter. One of these days I'll move beyond Visual FoxPro 6. 😀

Hugo Kornelis (8/9/2012)

---

Ken Hiatt (8/8/2012)

---

Still not believing it was that simple, I clicked Execute and got an error message stating that it couldn't find the stored procedure ISNULL. WTF...

I too was looking for the catch. So I looked up the command in the help, just to make sure I wasn't forgetting about something obscure. Nothing weird, so I...

LOL

I say we throw the whole thing out like the question never existed, no one got it wrong and no one go it right. We'll just call it a...

Apparently it's a good thing my knowledge is limited and I didn't put too much thought into it, I got it right.

I figured if any part of a transaction failed,...

There is a slight problem with your first IF statement if you truly intend for the delimiter to be "... any weird combination of characters that you think is unique...