Number validating

[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

[debasisdas]

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

[Singlem]

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

[debasisdas]

This may help.