Validate 10 digit Mobile number in SQL Server Database

narasima...

SOLVED CLOSED ACTIVE ANSWERED
User: narasiman
Posted: on Jul 02, 2013 05:10 AM
Forum: SQL Server
Replies: 1
Views: 5914

i want to validate three conditions in mobile number using sql server as follows; The mobile number should not start with number zero. The mobile number should not be null The mobile number should not exceed 10 digits

i am using the datatype varchar.

please help me.

how can i validate using sql server.

Rgds,

Narasiman P.

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
User: Mudassar
Replied: on Jul 02, 2013 05:10 AM
Report

Why you want to validate in SQL Server when it can be done easily on front end

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Validate 10 digit Mobile number in SQL Server Database

Company

Explore

Follow us

Contact Us