Good thoughts. I have to admit that the issue of injection attacks didn't even occur to me.

I remember an instance where I'd prefer the embedded code direction (and I'm...

I think I have the gist of what you're asking. Can you supply some specific examples?

Okay . . . that wasn't made clear in your original post, and I did not get that at all. (Just for your future reference, you should make...

Just telling us what the output is supposed to look like doesn't help at all. Can you give us an actual example of how you want your output to...

Camden Yards and Coors Field are both great ballparks! I also like Safeco Field in Seattle. SkyDome (now Rogers Centre) is also another interesting ballpark as well.

I also...

I think you'd be better off doing it like this:

update table

set col1=value, col2=value+some value

Note: the "value" in col2 is (hopefully, obviously) the same one that you put into col1.

Ack . . . I just re-read the previous postings. Shows you what happens when I skim through posts rather than absorbing them!

I can definitely see your point...

How often do we refer to a "CPU" as an entire computer case when really all it is is a component inside?

Similarly, a lot of people refer to the words...

COLD!!!

Single-digit and negative Fahrenheit temps here in upstate New York!

Steve -- it was your user point level names that prompted me to start this thread in the first place! 🙂 (Love your editorials, BTW!!!)

My sister-in-law lives in Denver,...

I just tried running your query on one of my own tables that has dates, and didn't have a problem.

BTW, Grant is correct . . . you should avoid...

If my team wins, it's worth it! 😀

One of us usually ends up sleeping on the couch! 🙂

I'd be surprised if there isn't one out there somewhere. I actually found the baseball database by doing a Google...

Yeah, lifelong upstate New Yorker here.

It also occurred to me that maybe this thread does have something to do with SQL. One of the things I've been doing with...