Home Forums SQL Server 2005 T-SQL (SS2K5) Search does not work on varchar(max) RE: Search does not work on varchar(max)

  • June 1, 2009 at 2:11 pm

    #1003018

    I am sorry for not providing data lynn.

    Data is a follows.

    INSERT INTO testcases ([testcase_id],[ScenarioName],[scenario_category],[expected_bundles],[expected_promotions],[on_order],[on_profile],[Change_to],[creation_date],[user_name])

    VALUES ('2737','[Change5]-[Existing Customer]-','Change','','AutoAdd: 1.24 M PL ','','FE / FDV + Data + Video Triple','FE / FDV + Data ','','')

    INSERT INTO testcases ([testcase_id],[ScenarioName],[scenario_category],[expected_bundles],[expected_promotions],[on_order],[on_profile],[Change_to],[creation_date],[user_name])

    VALUES ('2738','[Change6]-[Existing Customer]-','Change','','AutoAdd: 1.24 M PL ','','FE / FDV + Video SPL FL DCT wi','FE / FDV + Data ','','')

    INSERT INTO testcases ([testcase_id],[ScenarioName],[scenario_category],[expected_bundles],[expected_promotions],[on_order],[on_profile],[Change_to],[creation_date],[user_name])

    VALUES ('2739','[Change7]-[Existing Customer]-','Change','','AutoAdd: 1.24 M PL ','','FE / FDV + Data +Video SPL FL ','FE / FDV + Data ','','')

    Regards

    Jus