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),.t.,.f.)
Is it
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 better way, but I
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
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
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?
If so you have
5 matches
Mail list logo