extracting first 2 characters from VAT number

[wilkob]

Hi,

I have a long list of customers / suppliers and their VAT numbers. I would like to create a query that shows only the customer/supplier number and the first 2 characters (countrycode) from their VAT number. for example

Supplier 3 VAT number NL80980808
endresult should show:
3 NL

Is there anyone that can help me out??

 

[FoFa]

Use LEFT([VatNumber],2)