Thanks for the reply. I can't get that to work but it seems the IS NULL syntax, as in "IF @Param IS NULL", works at least for my limited testing.

The weather here is WAY too good to be typing stuff into a computer!

Gary

>>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.
>
>I haven't tried this in SQL Server, but you could check the length of the string if its equal to 0 or string = "" or similar.
>
>How's the weather down there today? Its great in St. Cloud, about an hour and a half left ... :-)