hi, hope someone can help me on this...
this pull out all my words...
<cfloop index="i" list="#subject#" delimiters=" .,?!:<>">
<cfif Len(i) GT 3>
<cfif listFindNoCase(goodlist, i) eq 0>
<cfset goodlist = ListAppend(goodlist, "%#i#%' OR subject LIKE '", " ") />
goodlist is now this...
'%What%' OR subject LIKE ' %methodology%' OR subject LIKE '
i want to now take my words and search...
WHERE subject LIKE '#goodlist#'
but as you can see the sql is wrong, i get one too many OR subject LIKE and at the end 2x '
anh help to make the string vailed sql?