AnsweredAssumed Answered

Does anyone know how to use a wild card if then statement in field calculator?

Question asked by Dan.Crawford_bcgov03 on May 5, 2017
Latest reply on May 5, 2017 by bixb0012

I'm trying to setup a simple if then statement that uses a wildcard:

 

If [SPECIES_CD_2] = "B" Then              ** this statement works but

If [SPECIES_CD_2] LIKE "B*" Then       ** this statement doesn't

 

I've tried substituting %, #, & for the asterisk but I keep getting an error (sub or function not defined)

 

Help!!!

Outcomes