IsDate checks that the format of whatever you have in quotes would convert to a date. So - the format has to be right, AND it would have to...

....

declare @myanswer bit

select @myanswer=isdate('11/24/1998')

....

isdate returns 1 if valid 0 otherwise (valid also means in a range SQL can store).

Absolutely...

Grant Fritchey (10/26/2007)

---

Yep. All sounds real good. I agree with every aspect. And yet, when the boss's, boss's boss sends the word down... We install the software and then do...

Since I doubt heavily that they are paying you for experience you don't have....learn as fast as you can, learn to be good using the tips above, and THEN look...

Kenneth -

when you take out the time to actually return the results - the performance is disgusting. Or rather - the performance difference is astounding.

Of course - on...

A few things:

- while .NET does make it relatively easy to go either way, it's not the only language. Most of the other solutions tend to have issues...

I know Jason - I was just answering OP's question directly...

I need to clarify who I'm speaking to:)

I'd think Regex using CLR integration. Specifically a CLR Table-valued function.

If you created the right Regex, then simply ran the MATCHES method - you'd end up with an array...

well - bad results or no bad results, you do want to avoid functions in your ORDER by. That's one where performance will SUCK.

Sort by the real date, display...

Also - are the network links between the two slow? It may at least partially be due to network latency. If so - you might consider have a...

you CAN use a case statement in your where clause, but not in the way you're looking at it.

The CASE statement can only return a scalar value, not...

I kind of chuckled the other day when I came across one of the Microsoft blogs referring to the "running totals" syntax we keep reusing as the "inner loop" and/or...

Of course - once you HAVE the table name like Lowell pointed out - you're heading into Dynamic SQL land...

Also - the old syntax is considered deprecated, so will likely be going away soon....