"Immy" <therealasianb***@hotmail.com> wrote in message news:...
> IF (SELECT COUNT(*) AS 'Number of Rows' FROM ManualContribution>0)
> Insert Records into table
>
>
> You don't need the else in this occassion.
>
>
> "Stephen Lynch" <raider1rai***@yahoo.com> wrote in message
> news:44f84aee$0$3572$815e3792@news.qwest.net...
>> ALL;
>>
>> How do I DO Nothing if my IF statement is false?
>>
>> For example:
>>
>> IF (SELECT COUNT(*) AS 'Number of Rows' FROM ManualContribution>0
>> DO NOTHING
>> Else
>> Insert Records into table
>>
>> Thanks
>>
>> Steve
>>
>>
>>
>>
>>
>
>