I am retrieving about 15 fields that I need to convert into a single plain English Description.

Here is the Select Statement:
    SELECT dbo.TblRIInventory.DocFeeder AS DocFeeder, dbo.TblRIInventory.FeederModel AS FeederModel, dbo.TblRIInventory.Duplex AS DupLex,
        dbo.TblRIInventory.LCT AS LCT, dbo.TblRIInventory.Cassette AS Cassette, dbo.TblRIInventory.PrintOpt AS PrintOpt,
                     dbo.TblRIInventory.NICOpt AS NICOpt, dbo.TblRIInventory.FaxOpt AS FAXOpt, dbo.TblRIInventory.PrintModel AS PrintModel,
                      dbo.TblRIInventory.FaxModel AS FaxModel, dbo.TblRIInventory.ScanOpt AS ScanOpt, dbo.TblRIInventory.ScanModel AS ScanModel,
                      dbo.TblRIInventory.SorterFinisher AS SorterFinisher, dbo.TblRIInventory.SorterModel AS SorterModel
    FROM dbo.TblRIInventory
     WHERE (dbo.TblRIInventory.ItemNumber = @ItemNumber)

(Originally I did this without the AS Statements)

Now based on the value of the entry, I wnat to include it into a variable @Description Declared nvarchar(255).

Using:
SELECT @Description = DocFeeder FROM dbo.tblRIInventory
 I received the first columns data, however
Using:
    SELECT @TempString = FeederModel FROM dbo.TblRIInventory
@TempString nvarchar(255)
I received Null Data.
I know that the second column has data in it.
I cannot beleive that the only way for me to get the data I need and to manipulate it is by:
    SELECT @Description = DocFeeder FROM dbo.tblRIInventory WHERE dbo.TblRIInventory.ItemNumber = @ItemNumber
    SELECT @TempString = FeederModel FROM dbo.TblRIInventory WHERE dbo.TblRIInventory.ItemNumber = @ItemNumber

I cannot beleive the overhead that this approach would cost. A read for every field.

Let me know if their is an alternative.

Alan

The question is not clear to me, Are looking for the "COALESCE" function which Returns the first nonnull expression among its arguments.

Actually, I am parsing the data to develop a description of the itme.
We are in the Copier Lease resale market, so each unit has a unique description.
What type of Feeder, does it Duplex, does it have a printer interface, etc.

The data is either a Bit type or a nvarchar depending on whether it is a description of an option, or whether a certain option exists on this unit.
I realize now that I am running subqueries on a query for the specific item, to determine the status or description of an option.
It's alot of code, but it appears to be working.
In VBA I could do it in less then half the statements I am using for the sproc.
I want to move as much of the coding to sprocs, triggers, and user functions that I can. Making it easier to support and modify.
Thanks for the reply.

We could help you , Seeing the vba code how to convert it to SQL.