Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Joining Tables and NULL value
Message
From
17/11/2003 14:31:28
Adam Davis
Meadewillis
Montréal, Quebec, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Joining Tables and NULL value
Miscellaneous
Thread ID:
00846508
Message ID:
00850735
Views:
17
SELECT IIF(ISNULL(TABLE.date),{//},TABLE.date) AS Boldate

or if it's a char field with len(25)

SELECT IIF(ISNULL(TABLE.value),space(25),TABLE.value) AS cval
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform