I have a issue that my application in currenlty doing number validation with an issue.

I have a query that checks number is stored procedures but need more checks.

[-d0-9] and checking that the lenth is 10 characters, all that is working as it should. The issue I'm having is: '0000000000', '1111111111',....,'9999999999' that passes my checking but is there a Regular Expression to check for these?

kind regards

Why are you storing number as characters why not as numbers ?

O sorry should have put that a bit better...Its telephoon numbers

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.