The compress function removes specified characters. The default is blank characters.
index(upcase(compress(ReviewText),'SOUNDBAR')>0
Alternatively, you can use the FIND function where you can specify a modifier to search with case insensitivity.
find(compress(ReviewText),'soundbar','i')>0
would locate SOUNDBAR, SOUND BAR, soundbar, sound bar, SoUnd baR, etc. Find: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002267763.htm Compress: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212246.htm
... View more