SQL Server Performance

contains

Discussion in 'SQL Server 2005 General Developer Questions' started by arkiboys, Mar 24, 2009.

  1. arkiboys Member

    It seems Contains does not allow for placing the word "NOT" at the beginning as follows:
    ' NOT "Hello you" AND NOT "office"'

    Is there a way so that I can have the word not at the beginning in the text please?
    Due to existing codes, I am trying to avoid using not contains(
    instead I must be able to use something like:
    contains(FieldName, 'not "hello there"'
    Thanks

Share This Page