title: creating a password field in SQL SERVER 2008
body: <p>i have to create a password field for my Diver table,
  the password has to be exactly 8 characters, and only numbers (0-9) and letters (a-z) are
  allowed. how do i do that?</p>
  
  <p>i tried:
      create table tblDiver
      (
      DiverNumber int primary key,
      DiverPassword char(8) not null CHECK (DiverPassword like '[0-9][0-9][0-9][0-9][0-9][0-9]        [0-9][0-9]')
      )
  but of course it only gives me to put only numbers.. i want letters also</p>