ELIMINATE EMPTY FIELD

From: solomon sackey


	texas Texas - United States
	solomon sackey

Subject:	ELIMINATE EMPTY FIELD
Thread ID:	195151	Message ID:	195151	# Views:	1	# Ratings:	0
Version:	Visual FoxPro 6		Category:	Databases, Tables and SQL Server
Date:	Friday, September 19, 2008 2:50:53 PM

Dear Expet

A select statement to eliminate empty field SPOUSE

SELECT VPAYMAST.DEPT, VPAYMAST.DEPTNAME,;
FROM VPAYMAST;
WHERE NOT EMPTY(SPOUSE) OR SPOUSE !=ISNULL(); INTO CURSOR SPOUSE

Thanks

ENTIRE THREAD

ELIMINATE EMPTY FIELD Posted by solomon sackey @ 9/19/2008 2:50:53 PM

RE: ELIMINATE EMPTY FIELD Posted by Anil Sharma @ 9/19/2008 2:58:06 PM

RE: ELIMINATE EMPTY FIELD Posted by Cetin Basoz @ 9/19/2008 3:37:54 PM

RE: ELIMINATE EMPTY FIELD Posted by Jim Booth @ 9/19/2008 6:12:08 PM