How can I search in a description field by the character "?"?

[eddysanchez]

I need to search in a specific description field all that are questions, so the rule is ending in "?"

When I did "like *?" the result is not correct because search ? = any one character

Regards

[#2]

What about if(Right(Text,1)='?',1,0)?  Should work.

[eddysanchez]

I needed to search '?' in the middle of the text

I used:

if(Replace(Text,'?','|') like '*|*',1,0)

But there should be a better way...

[kaushiknsolanki · Accepted solution]

Hi,

     You can use the Index function.

     something like this.

     if(index(FieldName,'?')<>0,1,0) as Flag.

     Index function will give you the position of '?' in the field, if it doesnt find then it will return 0.

     Hope this help.

Regards,

Kaushik Solanki

[swuehl]

findoneof(Text,'?')

[#6]

I have used something very similar to this before, I recommend it.