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 empty(). When I tries is not null it returned
everything.
Thanks
Judith
Judith Barer
Star-K Kosher Certification
122 Slade Ave
Baltimore, MD 21208
410 484 4110
Fax 410 653 9293
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
©2007 Judith Barer |
