Home Forums SQL Server 2005 T-SQL (SS2K5) T-SQL CONTAINS RE: T-SQL CONTAINS

  • June 18, 2008 at 4:52 am

    #830293

    umaramiya (6/18/2008)

    I have created a function which has varbinary and keyword as varchar(100) as parameters.

    I need to find whether the keyword (@Keyword) is in the varbinary (@Resume) variable and return the flag (@Exists) accordingly.

    @resume - varbinary

    @Text - varchar(100)

    @Exists bit return

    If CONTAINS(@Resume,@text) set @Exists = 1

    the above shows syntax error. How to achieve the above results.

    Help me please :crying:

    I would fail since CONTAINS must have column name or column list as first argument. Can you please detail your exact requirement? I don't think its good idea if you are doing it in scalar function. A table valued function should be a good choice here.

    Regards
    Shrikant Kulkarni