>>Sure Steven should use parameters.
>>BTW isn't Steven use .NET?
>>Why the question is in VFP forum? :-)
>>I assume this just because of this: arg1.trim().toUpperCase() :-)
>>If it was UPPER(ALLTRIM(arg1)) :-) ...
>
>It did look like a mix of .NET and VFP code.
>
>I would just do this in SP instead.
If you have choice :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.