VIEW or Stored Proc - Is this even possible?

Hello All,

I am wondering if this is possible and how.

I have a table with fields A, B, C, D and E. Any of these can contain nulls.
What I need to do is to be able to perform a select that removes nulls.

EG:

if A = 'A'
B = NULL
C = NULL
D = 'D'
E = 'E'

what I would like returned is

A, D, E, NULL, NULL.

Can anyone suggest a way to do this? I will need to select from this and
hopefully add som simple conditions.

Would a VIEW be the way to go or will I have to use a stored procedure?

Regards,

Stephen.
x 5125

-------------------------------------------------------------------------------------------

Copyright material and/or confidential and/or privileged information may be contained in this e-mail and any attached documents. The material and information is intended for the use of the intended addressee only. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you may not copy, disclose, distribute, disseminate or deliver it to anyone else or use it in any unauthorised manner or take or omit to take any action in reliance on it. To do so is prohibited and may be unlawful. The views expressed in this e-mail may not be official policy but the personal views of the originator. If you receive this e-mail in error, please advise the sender immediately by using the reply facility in your e-mail software, or contact postmaster(at)bmwfin(dot)com(dot) Please also delete this e-mail and all documents attached immediately.
Many thanks for your co-operation.

BMW Financial Services (GB) Limited is registered in England and Wales under company number 01288537.
Registered Offices : Europa House, Bartley Way, Hook, Hants, RG27 9UF
------------------------------------------------------------------------------------------