Check out ISNULL or COALESCE in BOL. Should give you what you need here.

Try something like ISNULL(E.Name, F.Name) Name in your select.

Yes, you can do that. I'd switch to using the new join syntax and not the old ANSI style stuff though. That would make that query look closer...

Yeah, doing things like that is no problem.

I'm still a little unclear on your requirements. Can you provide the results you are trying to get?

This is a guess and might be the whole thing you're trying...

If you're really getting into the thousands of splits in a string, you're probably well into CLR territory.

WHAT?!?! SOMEBODY was gonna say it.

You could also explore DDL Triggers to update the function when the table was updated. In general though, don't use SELECT *.

Yep, that's the gist of it.

The concept Lowell is explaining is often referred to as Deferred Name Resolution.

As elutin points out, you have options, but if you definitively want a calculated field that accesses data from another table, you have to create a function and then call...

You can turn use this to turn SQL into the most expensive calculator ever 😀

SELECT 5000/34.2

karthikeyan-444867 (5/20/2010)

Welcome to Microsoft SQL Server version 2005 and higher query optimiser.

IT MAY HAPPEN! As optimiser may deside to evaluate devision result before applying WHERE filter (or JOIN) and return...

Did it look like REPLACE(yourstring,'Odd Little Squares','') ? Cuz that's not gonna work at all! =).

Replacing things like that without knowing what they are can be a pain, you...

To know that much about SQL Server... AND be able to write C# code. Way to make the rest of us look like schmucks ;-).

I was thinking the same thing... but it may just be the language barrier. Aside from the request...

Wow. I had no idea windows XP had been around that long. Apparently it came out in 2001 though. I only started using XP on my home...