If you're in a case insensitive collation you can try taking out the UPPER() and tell the app guy to deal with formatting it on his end.

So first, you'll need a new column on the table with a datetime datatype, you will not be able to store a date formatted like '1992-05-26' in a float column....

Well the result you asked for doesn't match the pseudo code at all, what gilbert posted will get you the results you asked for.

But if you want to...

You can't give him access to just that table the permissions will be lost as soon as he drops it the first time, try looking at using EXECUTE AS in...

I doubt it's really as free form as take off whenever you want, unless you're working almost exclusively on solo projects that require little to no interaction with others that...