No, BEGIN is nothing like THEN. Unlike in VFP, only the first statemet after IF will be executed in T-SQL when IF condition is true. To execute more than one statement, you've to enclose them into BEGIN...END blok.



>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.
>