SQL Question - Creating a View

From: <NeedaHoliday>
Date: Tue, 16 Jun 1998 12:19:16 GMT
Message-ID: <358660e1.459154_at_news.pwgsc.gc.ca>

[Quoted] I am creating a view that requires the capability to do the following:

• I have a table with three address lines. They can contain information or be null. The requirement is, scan each address line
  (1,2,3). If address line 1 contains data, populate the view. If
  address line 1 is null, check 2 and so on. Out of all address lines
  (1,2,3) populate the view with the first address contain information.
  I tried the DECODE to no avail. Is there another function I can use?

Help

Jim Stewart
james.stewart!!pwgsc.gc.ca

Substitute !! with _at_ for my email address (SPAM Guard) Received on Tue Jun 16 1998 - 14:19:16 CEST