• There's no such syntax. If you want to compare to all the columns, you have to explicitly compare to all columns.

    So, in this case

    SELECT Name, Age, Description, Field1, Field2

    FROM MyTable

    WHERE Name LIKE 'Something%' OR Description LIKE 'Something%' OR Field1 LIKE 'Something%' OR Field2 LIKE 'Something%'

    I left age out of the where because I assume it's numeric and doing a like comparison with a string would probably give a conversion error.

    Just note that this is likely to perform poorly on larger tables because it will very likely table scan.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass