cfml

Hi Folks!

While doing substring search I am facing issue when substring contains *or* keyword in it then it return false result

Any work around for it?

I must not understand what you're doing or expecting. Are you really looking for "multiple emergency department visits..." in whatever the value is in getStartofCare.F143)? Seems unlikely.

The test I did with the word "or" in the string being searched for returns 0 as expected.

I am doing
&lt;cfdump var='#findNoCase('Multiple hospitalizations (2 or more) in the past 6 months', '3. Multiple hospitalizations (2 or more) in the past 6 months!6. Reported or observed history of difficulty complying with any medical instructions (for example, medications, diet, exercise) in the past 3 months',0)#'&gt;

It is returning 4 as result on
<https://cfdocs.org/findnocase>
but trying on my development server giving 0 as result

Because this substring `Multiple hospitalizations (2 or more) in the past 6 months` is found, and it starts at the 4th character of the string it's looking in, so it's true with 4 returned, as expected.

yes but in my server it is returning 0 when value is usedas variable

```&lt;cfset variables.sentence = "3. Multiple hospitalizations (2 or more) in the past 8 months!6. Reported or observed history of difficulty complying with any medical instructions (for example, medications, diet, exercise) in the past 3 months"&gt;

&lt;cfdump var='#findNoCase('Multiple hospitalizations (2 or more) in the past 6 months', #variables.sentence#,0)#'&gt;```

Oops sorry, I had changed the text while messing with it.

Now I get the expected result
```&lt;cfset variables.sentence = "3. Multiple hospitalizations (2 or more) in the past 6 months!6. Reported or observed history of difficulty complying with any medical instructions (for example, medications, diet, exercise) in the past 3 months"&gt;

&lt;cfdump var='#findNoCase('Multiple hospitalizations (2 or more) in the past 6 months', #variables.sentence#,0)#'&gt;```

when I did execute your above code then it throws me he eror

<https://trycf.com/gist/8a09c55fe5054b23a2eeaa499b3b87e2/lucee5?theme=monokai>

try <https://trycf.com/gist/e1e14393425d0bda4e14c314524facd5/acf2021?theme=monokai>

I got the issue now the main string should be wrap with in quotes :stuck_out_tongue:

very strange thing happening again
when I do find with query column name then nothing found
But If I declare the static variable which you did then it work smoothly

Both are same but showing different results

The below result NO NO should also be YES YES