Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: solomon sackey
  Where is solomon sackey?
 texas
 Texas - United States
 solomon sackey
 Tags
Subject: RE: NVL for each field
Thread ID: 228580 Message ID: 228584 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, May 20, 2009 4:12:01 AM         
   


> Dear Expert,
>
> Need to introduce NVL() on each of the fields AQUAL1, AQUAL2
>
>
> Pls assist
>
>
>
>
>
> SELECT * FROM VPAYMAST WHERE LCTEXT)$(UPPER(AQUAL1)) OR LCTEXT$UPPER(AQUAL2) ;
> ORDER BY BRANCH,LNAME;
> INTO CURSOR VPAYMAST

http://msdn.microsoft.com/en-us/library/aa978053(VS.71).aspx

Best Regards,

CriZ (,")

"Happiness is real when shared."

ENTIRE THREAD

NVL for each field Posted by solomon sackey @ 5/20/2009 3:35:40 AM
RE: NVL for each field Posted by Christian Tabligan @ 5/20/2009 4:12:01 AM
RE: NVL for each field Posted by Anders Altberg @ 5/20/2009 11:16:09 AM