Password check / special characters

• Kevin-130791

  SSChasing Mays

  Points: 622

  More actions

  March 19, 2007 at 9:15 am

  #172464

  Is there a function to check for special characters in a string (<,./">!@#$%^&*()?><,./  I would like to write a routine that will check if a user password has one of these values & is seven characters long.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  March 19, 2007 at 9:41 am

  #695752

  like '%[(!@#$%^&*()?><,./]%'

• Peter E. Kierstead

  SSCarpal Tunnel

  Points: 4114

  More actions

  March 21, 2007 at 12:44 pm

  #696230

  Or, more generically,

  like '%['+Char(0)+'-'+Char(31)+Char(127)+'-'+Char(255)+'!@#$%^&*()_+=-]%' Collate Latin1_General_BIN

   

  ---

  
  PeteK
  I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.