954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Number validating

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

Singlem
Light Poster
49 posts since Feb 2010
Reputation Points: 10
Solved Threads: 8
 

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

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

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

Singlem
Light Poster
49 posts since Feb 2010
Reputation Points: 10
Solved Threads: 8
 

This may help.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You