Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF character length?
Message
From
03/06/2002 08:32:15
 
 
To
03/06/2002 08:14:51
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00663995
Message ID:
00664004
Views:
25
To make it simpler:
SELECT IIF(empty(dtcompl),"''","'" + DTOC(dtcompl) + "'") from mevmast where citat LIKE 'BA83311%'

results in '0

SELECT IIF(empty(dtdisp),"''","'" + DTOC(dtdisp) + "'") from mevmast where citat LIKE 'BA83311%'

results in '10/26/90'

Both fields are of the date type, length 8, and contain a date value. What could cause this?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform