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 return False/True or 0/1 for your logical sample above.
Select ISNULL( addl_loc_info , false )
From yourtable
HTH
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown
http://spaces.msn.com/members/srussell/
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 1/30/2007
11:30 PM
©2007 Stephen the Cook |
