>I also remove any UPPER() functions because SQL Server doesn't support upper and it's not really necessary if you have it set to not use case-sensitive data.
>
>If a field doesn't accept nulls you'll need to supply some kind of values. This could be with a default in the server or by defaulting the value in the front end when the user adds a record. You could also just set the field to allow nulls is that's apprpriate.

Thanks!