Re: constraint question

what language are you using?  might be easier to perform the check
programatically and provide thoughtful feedback at that level as opposed
to a db constraint

just suggestion

On Mon, 1 Jan 2001 mwaples@optusnet.com.au wrote:

> I have table users with a varchar field user_name,
> Id like to restrict this to just alphanumeric characters 
> can I do this with a check constraint ?
> or do I need to use a tigger and function ?
> 
> I've read the docs but can't seem to get it right - Im sure its fairly
> simple and Id like to use it on a number of fields in a number of tables
> 


-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.    
+1 651.645.9798 fax            Don't forget your BackPack!"   
-----------------------------------------------------------------------------