Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fields NOT null
Message
From
13/01/2013 05:48:43
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01562353
Message ID:
01562354
Views:
44
>this Code give D02 with NULL value ?
 SELECT T.cnomteleph,;
    CAST(SUBSTR( TTOC(NVL(  A1.debut, { :} )) , 12 , 5 ), "" ) AS c(5 ) )AS  D01  ,;
...
... etc, wrap the field in nvl(), not the whole expression.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform