How about:
SET VAR vJunkFile TEXT = (FILENAME(0))
OUTPUT &vJunkFile
WRITE 'UPDATE ttblReportData SET', .vPctColName, '= +'
WRITE '((', .vDollarColName, '/', .vSalesLessReturns, ') * 100) +'
WRITE 'WHERE', .vDollarColName, 'IS NOT NULL AND +'
WRITE .vPctColName, 'IS NULL AND StatementType <> ''BS'''
WRITE 'RETURN'
OUTPUT SCREEN
RUN &vJunkFile
DELETE &vJunkFile
Bill
On Tue, 29 Jan 2002 08:56:02 -0800 (PST), Lawrence Lustig wrote:
>UPDATE ttblReportData +
> SET &vPctColName =
>((&vDollarColName/.vSalesLessReturns)*100) +
> WHERE &vDollarColName IS NOT NULL AND &vPctColName
>IS NULL +
> AND StatementType <> 'BS'
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
