Having the PRINT statement immediately after the IF means that it is what happens if the IF is true. The BEGIN END after the PRINT becomes just a statement block unconnected with the IF.

The BEGIN immediately after the IF means that the BEGIN END block happens only if the IF is true - it is directly connected to the IF.


>So, the BEGIN is almost like THEN? The lines before the BEGIN always exectute, but those inside the BEGIN only execute if the IF condition is true? If that is the case, then my IF condition must not be true for the behavior I'm seeing.
>
>>When IF condition is true, the PRINT will be executed in both cases. OTOH, the BEGIN...END block will be executed always in the first case.
>>
>>
>>>The PRINT statement executes:
>>>

>>>IF @Filename LIKE '%.tiff%'
>>>
>>>	PRINT @Filename
>>>
>>>	BEGIN
>>>
>>>		Some code here
>>>
>>>	END
>>>

>>>
>>>The PRINT statement does NOT execute:
>>>

>>>IF @Filename LIKE '%.tiff%'
>>>
>>>	BEGIN
>>>
>>>		PRINT @Filename
>>>		Some code here
>>>
>>>	END
>>>

>>>
>>>Why?