I guess you misplaced your displeasure. <g>

>*Red Red Face* Thank you, Sergey, that is it.
>
>>What double quotes are doing in the statement?
>>
>>>
>>>First, let me get this off my chest. "I Hate SQL Server Help! I Hate SQL Server Help! I Hate SQL Server Help!"
>>>
>>>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 != ''
>>>

>>>
>>>I run it and get these errors:
>>>Msg 4104, Level 16, State 1, Line 1
>>>The multi-part identifier "RunRoute.RunRte_Run_AutoID" could not be bound.
>>>Msg 4104, Level 16, State 1, Line 1
>>>The multi-part identifier "RunRoute.RunRte_Rte_ID" could not be bound.
>>>Msg 4104, Level 16, State 1, Line 1
>>>The multi-part identifier "RunRoute.RunRte_Rte_ID" could not be bound.
>>>Msg 4104, Level 16, State 1, Line 1
>>>The multi-part identifier "RunRoute.RunRte_Rte_ID" could not be bound.
>>>
>>>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