Home Forums SQL Server 7,2000 T-SQL Search for string occurrence RE: Search for string occurrence

  • August 30, 2006 at 9:17 am

    #657572

    select

    distinct object_name(id) from syscomments where text like '%DDENT%'

    This will return the object names that contain the string "DDENT".

    Hope that helps,

    Karl
    source control for SQL Server