Home Forums SQL Server 2005 SQL Server Newbies Return value if field not there in Query RE: Return value if field not there in Query

  • September 24, 2013 at 12:16 am

    #1652570

    tibco29 (9/11/2013)

    I want to check field/column exist or not in a table and populate the value

    Example: Does the column1,column2 exists:

    case1:return column1 and column2

    case2:return column1 or column2

    case3:return column1

    case4:return column2

    case5:return '0'(no columns)

    How can I achieve this?

    I think what you mean is: If column1 exists then populate column1 with a particular value else ignore. Right?