f4c7901b   
   From: reb01501@NOyahooSPAM.com   
      
   emanning wrote:   
   > I have a view that returns rows from a table and would like to add an   
   > extra row to the result set, but don't want to add that row in the   
   > table.  How do I do this?   
   >   
   > My view returns:   
   >   
   >      Mickey   
   >      Minnie   
   >      Donald   
   >   
   > I'd like the view to return but don't want "NA" added to the table:   
   >   
   >      Mickey   
   >      Minnie   
   >      Donald   
   >      NA   
   >   
   aargh, and my suggested query was relevant to JetSQL, not T-SQL. In T-SQL,   
   one does not need a FROM clause so my suggestion can be simplified to:   
      
   select disneycharactername from disneycharacters   
   union all   
   select  'NA'   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)