Re: How to best accomplish selecting string (unless it is null)

On Sat, Oct 25, 2003 at 11:49:46PM -0500, Adam Clauss wrote: > I have a select statement that selects two string (text) fields. In some > cases, the first of them may be NULL. In this case, I would like the second > field to be selected instead. It is also possible that in rare cases that > the

Re: How to best accomplish selecting string (unless it is null)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I have a select statement that selects two string (text) fields. In some > cases, the first of them may be NULL. In this case, I would like the > second field to be selected instead. It is also possible that in rare > cases that the second string

How to best accomplish selecting string (unless it is null)

I have a select statement that selects two string (text) fields. In some cases, the first of them may be NULL. In this case, I would like the second field to be selected instead. It is also possible that in rare cases that the second string may be NULL, in which case it should just return NULL.