It really depends on the codepage used for the database.

By default the database is set to "case insensitive"
This means that 'walter' and 'WALTER' are equal.

In that case, the is no need to use UPPER() at all

Walter,




>I have changed this post a couple of time. And now, after all, I decide to ask the question:
>
>Does it matter if the SQL Select (in stored procedure) is
>

>where upper(@SID) = upper(SID)
>

>or
>

>where upper(SID) = upper(@SID)
>

>
>That is, if a variable is compared to the field or the other way around.
>
>The @SID is the passed value and the field name in the table is SID
>
>TIA