Locating a particular word in String field

[rico7937]

I am using Crystal Reports V10. I am working with problem mgt. tickets and there is a field called problem abstract which is a string field (60). I am trying to write a statement that will allow me to search this string field and pull any tickets with the word "Visalia" in the field.
This is what I am using and it's not pulling all of the tickets due to different variations.(Ex. NCCF/VISALIA, REKV-VISALAI, RUSH:VISALIA...)

Here is my coding statement:

{PROBLEMS.OPEN_DATE} in YearToDate
and
{PROBLEMS.PROBLEM_ABSTRACT} like ["Visali*"]

Any help would be greatly appreciated !

 

[dgillz]

Use the instr() function:

instr({PROBLEMS.PROBLEM_ABSTRACT},"Visalia")>0

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[MCuthill]

Rico:

I beleive that you can also use:

"Visalia" [blue]IN[/blue] {PROBLEMS.PROBLEM_ABSTRACT}

Depending on CASING of your field you may also want to use:

"VISALIA" [blue]IN UpperCase[/blue]({PROBLEMS.PROBLEM_ABSTRACT})

Hope This Helps,

Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[lbass]

I would use a SQL expression to convert the field to upper case, as in {%probabst}:

ucase(problems.`problemabstract`)

Then use that in your record selection formula, limiting the text to that which you think is consistently present, like:

{PROBLEMS.OPEN_DATE} in YearToDate
and
{%probabst} like "*VISAL*"

-LB