HELP with SYNTAX!!!!!

From: Vic Millan <vmillan_at_dailyherald.com>
Date: Thu, 02 Sep 1999 14:18:02 GMT
Message-ID: <37ce8704.8064635@news.alterdial.uu.net>

Hello,

I hope someone can correct my syntax with ths line of code:

IF ('#LIPREPAY#' = 'CC' and '#PREPAYAMOUNT#' = select amount from prepayment where adno = '#ADNO#' and vno = 'Y')

it doesn't seem to like the statement after the AND. What i am trying to do is compare the amount that is given to an amount that is stored in prepayment. Any help would be appreciated..

Vic
vmillan_at_dailyherald.com Received on Thu Sep 02 1999 - 09:18:02 CDT