Formatting (Checking) a Phone Number entry

[anonymous]

Hi. I’m trying to validate a phone number to check that it starts with a 0, at position 6 is a space and its length is 12. Here is the statement that I use

Here an example of the number 01234 567888

However, it fails to validate a correct entry

Any helps would be appreciated

Thank you in advance

[Aleksi]

Your LEFT expression’s result is "01234 ", not a space. Instead of using LEFT, you should use MID().

[anonymous]

Of course! It’s Monday! What can i say?

Thanks Aleksi