QRY question: If field1 is null then field2 -- sql server mseq

Dan
3/24/2004 10:25:11 AM

Is there a way to create a column that will show the
value of field1 unless field1 is null in which case it
will show the value of field2? I do it all the time in
Access but can't seem to figure out if SQL Server can do
it as well. Any help or suggestions are geratly
appreciatd!

Here is how I do it in MS Access:
SELECT IIf([Field1] Is Null,[Field2],[Field1]) AS [Output]

Steve Kass
3/24/2004 1:35:43 PM

Dan,

In SQL Server, you can write

CASE WHEN Field1 IS NULL THEN Field2 ELSE Field1 END AS [Output]

Since this particular need comes up often, there is a shorthand form:

COALESCE(Field1, Field2) AS [Output]

Steve Kass
Drew University

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : QRY question: If field1 is null then field2