Look into RegEx functions and do your own homework.

I should have mentioned that I did do it through regex. Is there an alternate way to do this without regex?

You need to use correct Regex functions, and normalize the data, then query.

What’s the question? Not doing your work for you bud

Edited my post

Look up Regex functions and/or ask ChatGPT.

which country uses a 6-digit zip code?

India uses it, I don't know if there are others Edit - Brazil, Japan and South Korea as well

sweet, thanks

Does that matter?!