select values in script area

[Carlaf_93]

Good morning,

i have field named 'FILED1' that contains values like 'A1,A2,A3,B1,B2,B3...'

if i use this formula:

IF(MATCH(FILED1,'A1'),1,0) AS PIP,

i'm able to selct the value A1 throug PIP.

How cai i do if i want all elements starting with A?

Itried this... but doesn't work

IF(MATCH(FILED1,'A*'),1,0) AS PIP,

How can i do?

[Ivan_Bozov · Accepted solution]

IF(WILDMATCH(FIELD1,'A*'),1,0) AS PIP