Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: solomon sackey
  Where is solomon sackey?
 texas
 Texas - United States
 solomon sackey
 Tags
Subject: NVL for each field
Thread ID: 228580 Message ID: 228580 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, May 20, 2009 3:35:40 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

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