select * from vw_PublicPortal (nolock) where LOWER(ISNULL(CollaborationType, 'internal')) = 'public' and 1=1 and Vendor_ID = 340 order by VendorName