I guess I'm being stupid or something but I can't get anything like this to work. I simplified it to this:

Name like '^[A-Z]'

and then did the following insert,

insert into table...

Thanks!

Can you help me understand this syntax. I don't see anything here that limits the input to 20 characters, one capital charcter and then up to 19 lowercase characters.

Thanks again...

Thanks, such a simple answer. I have a real problem finding good examples of such things either on the internet or in the SQL books online.