Member Avatar for Singlem

Hi

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

  • 2 Contributors
  • 3 Replies
  • 108 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

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

Member Avatar for Singlem

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.