Thanks, that appears to do the trick. I've worked with Fox since the late '80s and miss the wealth of functions. I have to assume SQL Server will let me do what I need to do, but it ain't obvious at first glance.
gary
>Try
>
>if cYourParameter is null
> ...
>
>
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement