Yes, I have struggled with several language differences. I rely on the Books Online documentation that comes with SQL Server and a co-worker who is a DBA.
>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.