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