>Can you use a CASE statement in a VFP query (similar to SQL Server)? If not, what is the best way to populate a field if it is empty when running a query? I want it to have something like 'View Record' if the field is empty or the field value if there is something in the field. Hopefully this makes sense. Thanks.
>
>Doug
Isn't there a function like EVL()? I don't have Visual FoxPro handy right now, but that should be simpler than an IIF(). I think it would be similar to NVL(). (When you do an outer join, the records from one table that have no match in the other table have null fields for the other table.)
Craig Berntson mentioned that you can't really trust the size of the resulting field. This can be solved as follows:
The old-fashioned way: If EVL() works the way I am guessing, that would be something like evl(MyField, space(10)) - assuming the field has 10 spaces. Or for a numeric, evl(MyField, 0000000000). Or replace with an iif().
In VFP 9, this would be simpler, and more under your control, with the cast() function.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)