Authenticating Input on a fields

• SQLTestUser

  Hall of Fame

  Points: 3997

  More actions

  June 30, 2011 at 3:55 pm

  #243568

  IS there any way we can authenticate input with a trigger or a procedure or something else everytime a fields is update

  i am trying to authenticate a name filed and ensure that no special characters are entered on the field, the field is

  FirstName nvarchar(40)

  thanks

• Chrissy321

  SSCoach

  Points: 15766

  More actions

  June 30, 2011 at 4:18 pm

  #1346805

  The SQL server functionality you want to explore is CHECK constraints.

  CHECK constraints enforce domain integrity by limiting the values that are accepted by a column.

• Chrissy321

  SSCoach

  Points: 15766

  More actions

  June 30, 2011 at 4:21 pm

  #1346806

  http://mangalpardeshi.blogspot.com/2008/12/check-constraint-to-allow-alphabets.html