Using SQL Server 7, how would you write a check constraint for a varchar(25) column that would disallow spaces? (I'm guessing it would be a check constraint, if there is a better way, I'm all ears.) In other words, I don't want any spaces in the inserted text. What is the best way to validate this from the database side? Thanks in advance for your help! Jeremy ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
