ISNULL in view

• Bradlee

  SSC Veteran

  Points: 214

  More actions

  October 5, 2004 at 1:52 pm

  #162297

  trying to put a ISNULL in a view to caputure bad data and replace with proper flag but getting Create View or Function failed because no column name was specified for column error.  Is this possible and I have wrong syntac?

  example:

  ALTER   VIEW dbo.vwEmp

  AS

  SELECT DISTINCT

     isnull(E.Attempt,'A')

   FROM  tblEmp E WITH (NOLOCK)

   

  NEVER MIND....i FORGOT TO ENTER ATTEMPT AFTER THE BRACKETS......How do I delete this post?

• rs

  SSCrazy

  Points: 2819

  More actions

  October 6, 2004 at 7:29 am

  #525576

  Try this.

   

  ALTER   VIEW dbo.vwEmp

  AS

  SELECT DISTINCT

     isnull(E.Attempt,'A') AS Attempt

   FROM  tblEmp E WITH (NOLOCK)