USP_DATALIST_ORGANIZATION_SEARCH

                CREATE procedure dbo.USP_DATALIST_ORGANIZATION_SEARCH (
                    @SEARCHSTRING nvarchar(50) = ''
                ) as begin

                    select                     
                        C.ID,
                        C.NAME,
                        A.ADDRESSBLOCK,
                        A.CITY,
                        S.DESCRIPTION,
                        A.POSTCODE,
                        C.LOOKUPID
                    from
                        dbo.CONSTITUENT C
                    left outer join
                        dbo.ADDRESS A on A.constituentid = C.id
                    left outer join
                        dbo.STATE S on S.ID = A.STATEID
                    where
                        isorganization = 1
                        and (c.KEYNAME like '%' + @SEARCHSTRING + '%')

                end