>Do you need a 'from' clause after 'patients'? Or is 'Patients' the table. If a table, then do you really mean 'select'? I assume this is not a foxpro script.

>
>>This is the last line of my script:
>>
>>

>>Select Patients
>>

>>
>>I get this error:
>>
>>

>>Msg 102, Level 15, State 1, Line 258
>>Incorrect syntax near 'Patients'.
>>

>>
>>If I put something else at the end of the script, like this:
>>
>>

>>Set NOCOUNT OFF
>>

>>
>>Then the error is:
>>
>>

>>Msg 102, Level 15, State 1, Line 258
>>Incorrect syntax near 'OFF'.
>>

>>
>>What's going on?