AnsweredAssumed Answered

How do I find a single character value in a field

Question asked by andyk3005 on Jan 20, 2018
Latest reply on Jan 23, 2018 by osensnolf

I have data from a legacy system imported into filemaker.   A field has valid values C,CANS,CANB etc. I am running a scripted find where one criteria is the field value C.    I have tried various ways "C   ", escaping the "'s  but the result is either NIL returned values or all values beginning with C.  Their must be a simple solution. Can anyone advise

Outcomes