Home Forums SQL Server 2005 T-SQL (SS2K5) Full Text Search Wildcards RE: Full Text Search Wildcards

  • September 23, 2008 at 12:40 pm

    #875965

    select *

    from table

    where country in (@countryparameter)

    and customertype in (@customertypeparameter)

    and (@name IS NULL OR contains(name,@name))

    would this work?

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005