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 ... :-)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only