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 --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
