>>>>>>>I want to end the script at some point so the code after it does not run. I would just use CANCEL or RETURN in Forpro.
>>>>>>
>>>>>>Put GO statement to separate scripts from one another. It doesn't stop it, though, so you can use RETURN command.
>>>>>
>>>>>If GO doesn't stop the script, what does it do?
>>>>
>>>>GO is a batch separator and should be used ONLY in query window. You can't have GO inside Stored procedure or in script you sent from your FronEnd.
>>>>I'm not sure what you need here. If you want to execute only several lines from your script in query window just mark them and then execute selection. In other cases you have to put some error handling or additional logic to skip execution. If this is a SP you can have RETURN everywhere you need and that will stop execution of the lines follow that RETURN.
>>>
>>>Or block stuff you want or don't want to run in IF..EndIf statements and handle accordingly?
>>
>>Sure,
>>but there is no ENDIF in SQL Server :-)
>>There is only BEGIN .... END.
>
>You can tell I'm working on straight VFP today, eh?

That was very hard to guess :-)