what is the equivalent of operator LIKE in CSPro ?

Discussions about editing and cleaning data
Forum rules
New release: CSPro 8.0
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: what is the equivalent of operator LIKE in CSPro ?

Post by Gregory Martin »

Are the names on a repeating record? If so, you will have to specify the occurrence you want to check, or use a count/seek expression to check all occurrences, something like:
and count(NOM_PRENOMS_INDIVIDUS where startswith(toupper(strip(F69_DRAFT)), toupper(NOM_PRENOMS_INDIVIDUS))) > 0 do
Post Reply