phone no validation in sql server

Question

how to check stored phone number is a valid phone number in sql server...