Thanks for the suggestion.

Gary

>>Hi,
>>I'm converting a VFP app to run against an SQL Server backend so I'm having to put some of the functions into SQL Server sp's. I want to test a parameter sent to a stored procedure to see if anything was passed. In VFP I'd use empty() but nothing like that seems to exist in SQL Server. Anyone got any ideas? Thanks.
>
>
>You Could Use an expression like "LEN(ISNULL(@Param, '')) >0" to test if your Varchar variabile will not be NULL or Empty.
>
>Emanuele!