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?