Post reply

Inserting country code in the column of a table

  • November 8, 2011 at 11:59 pm

    #250531

    Hi All,

    Iam having a users table which contains "Mobile" column as well. I want a query to set the country code(+91) value by default into the column name so that the column should be updated with the mobile number along with the default country code. kindly help me on this with the query.

    Thanks,

    Ram

  • November 9, 2011 at 1:03 am

    #1405001

    Easy & Safe Solution: Validate mobile number before inserting into the table. This validation can be done at application (preferred) or in stored procedure in SQL Server. Don't validate it with CHECK constraint.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply