findstring

• ronan.healy

  SSCrazy

  Points: 2232

  More actions

  November 24, 2014 at 3:13 am

  #298839

  hi

  i have to use findstring to search for a certain word in a column

  eg

  (FINDSTRING(" " + UPPER(SecurityName) + " ","Swap ",1) > 0)

  if I want to do it where SecurityName does not equal wsaps do I just do it like this

  (FINDSTRING(" " + UPPER(SecurityName) + " ","Swap ",1) < 0)

  or is there a better way