There is a type, on the first line... should read:

>sSQLString = "SELECT User_Site.Contract_Prefix, User_Site.Contract_Code, User_Site.Site_Code, " & _

But, it is correct in the source code... sorry...

>Well, I am sure someone will point out my ignorance here, but I don't mind...
>
>.ASP generated script generates an error which I cannot put my finger on:
>
>

>sSQLString = "SELECT User_Site.Contract_Prefix, User_Site.Contract_Code, ser_Site.Site_Code, " & _
>
>"hygsite.Cust_Name, hygsite.Name_Text, hygsite.Addr_Text, hygsite.Addr2_Text, Hygsite.City_Text " & _
>
>"FROM User_Site, hygsite " & _
>
>"INNER JOIN Site_Code ON HygSite.Site_Code = User_Site.Site_Code " & _
>
>"INNER JOIN PortalUser ON User_Site.User_id = PortalUser.User_Id " & _
>
>"WHERE hygsite.Site_Code = User_Site.Site_Code " &_
>
>"AND User_Site.Site_Code LIKE PortalUser.Site_Mask AND User_Site.User_id = " & _
>
>nUserID & " ORDER BY User_Site.Site_Code"
>
>

>
>But when run, I get "Invalid Object Name: Site_Code"
>
>Any suggestions?
>
>TIA
>
>Ric