< snip > Hi Naomi,
Is IS NOT NULL sql server specific, or ANSII compliant?
And when we start our application we point to a specific database, they can not go to another database within the same session of our application. Do we need to specify the database?

Starting to SQL Server now, so am going to be asking lots of questions over the next month or so at least. :-D

Thanks for the info.
Beth

>>okay, now I have a select statement:
>>

>>SELECT DISTINCT RunRoute.RunRte_Rte_ID "
>>FROM RunRoute "
>>WHERE '20' = RunRoute.RunRte_Run_AutoID AND
>>RunRoute.RunRte_Rte_ID != 'NULL' AND RunRoute.RunRte_Rte_ID != ''
>>

>>
>
>IS NOT NULL instead of !='NULL'
>
>And RunRoute.RunRte_Run_AutoID = '20'
>
>Also you should specify database name.
>
>FROM dbo.RunRoute
>
>
>>I did several LARGE Select statements into temporary tables before this in the same query window, and they worked fine. This is to permanent tables and it errors on me. Help is not helping me on this.
>>
>>What do these errors mean, how can I check things for it?
>>
>>TIA
>>Beth