How to only keep data from a column that has a particular structure?

[Manuel174102]

Hello, I have the following data. For my analisis I only need the AB numbers, they all have the same structure which is AB0*****. How can I only keep them?

Greetings

What I have

Number

AB028394

AB057493

AN48394

KA75984

AN47398

What I need:

Number

AB028394

AB857493

[Or · Accepted solution]

Load Number

From YourTable

Where WildMatch(Number,'AB*');

[Manuel174102]

thanks. it worked