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!"
-----------------------------------------------------------------------------