Home Forums SQL Server 2005 T-SQL (SS2K5) problems using charindex function RE: problems using charindex function

  • February 27, 2009 at 5:07 am

    #951066

    Hi,

    this is my first reply - wow !

    set @charpos = charindex('and',@SearchTerm) instead of

    set @charpos = charindex(@SearchTerm,'and')