Hi Dmitry,

No, because both variants are slow - UPPER(FIELD).

MartinaJ

>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