>>
>>
>>> What would you use in an sql select statement for sql server to
>>> replace
>>> empty() function of vfp. I would like to do the following in t-sql
>>>
>>> Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
>>>
I never messed with it a lot, so there's probably a
MB Software Solutions <> wrote:
> Stephen the Cook wrote:
>> Judith Barer <> wrote:
>>
>>> What would you use in an sql select statement for sql server to
>>> replace empty() function of vfp. I would like to do the following
>>> in t-sql
>>>
>>> Select items.item_num , iif(!empty(addl_loc_info
Stephen the Cook wrote:
> Judith Barer <> wrote:
>
>> What would you use in an sql select statement for sql server to
>> replace
>> empty() function of vfp. I would like to do the following in t-sql
>>
>> Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
>>
>
> Is it null?
>
> I
Judith Barer <> wrote:
> What would you use in an sql select statement for sql server to
> replace
> empty() function of vfp. I would like to do the following in t-sql
>
> Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
Is it null?
If so you have isNull() or Nullif()
You will also
What would you use in an sql select statement for sql server to replace
empty() function of vfp. I would like to do the following in t-sql
Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
So I see that you need to use case instead of iif but I do not know what
to use instead of em
5 matches
Mail list logo