>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.
>
That is what he did in his second example and it wasn't working. If the Print executes after the IF statement then the IF must be true and it should execute when placed inside the Begin - End. And I think is why he is confused.
Tim
>
>>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.
>>
Timothy Bryan