Rule in Sql Derver

• rahuldesai009

  Newbie

  Points: 5

  More actions

  February 26, 2012 at 11:59 pm

  #150838

  How to create a rule in SQL Server which accpets only alpha numeric characters?

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  February 27, 2012 at 12:24 am

  #1451898

  Try to avoid using RULES , instead use check constraints.

  RULES are going to be Deprecated in future releases

  http://msdn.microsoft.com/en-us/library/ms143729.aspx

  Jayanth Kurup[/url]

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  February 27, 2012 at 6:50 am

  #1452037

  Use check constraint as adviced in previous post. See the sample:

  CREATE TABLE [dbo].[MyTbl](

  [Id] [int] NOT NULL,

  [AlphaNumericValue] [varchar](50) NULL

  )

  GO

  ALTER TABLE [dbo].[MyTbl] WITH CHECK ADD CONSTRAINT [CK_MyTbl_AlphaNumericValue] CHECK ((NOT [AlphaNumericValue] like '%[^0-9A-Za-z]%'))

  GO

  ALTER TABLE [dbo].[MyTbl] CHECK CONSTRAINT [CK_MyTbl_AlphaNumericValue]

  GO

  insert MyTbl select 1, 'assddas'

  insert MyTbl select 2, 'assddas1231231'

  insert MyTbl select 3, '1231231'

  insert MyTbl select 4, 'mnbasdk-asd' --this willl fail validation

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]