Re: sql server empty fields

2007-02-01 Thread Vince Teachout
>> >> >>> 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

RE: sql server empty fields

2007-02-01 Thread Stephen the Cook
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

Re: sql server empty fields

2007-01-31 Thread MB Software Solutions
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

RE: sql server empty fields

2007-01-31 Thread Stephen the Cook
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

sql server empty fields

2007-01-31 Thread Judith Barer
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