Home Forums SQL Server 7,2000 T-SQL How to! RE: How to!

  • December 14, 2004 at 5:19 am

    #533732

    SQL doesnot allow you to use derived column names in the where clause.

    You will have to repeat the formula in the where clause

    Kindest Regards,

    Sureshkumar Ramakrishnan