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(at)optusnet(dot)com(dot)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(at)backpack(dot)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!"
-----------------------------------------------------------------------------