USP_SEARCHLIST_GETSEARCHLISTSWITHQUICKFIND

create procedure [dbo].[USP_SEARCHLIST_GETSEARCHLISTSWITHQUICKFIND]

as    
    set nocount on;

    select 
        SEARCHLISTCATALOG.ID,
        SEARCHLISTCATALOG.NAME
    from 
        dbo.SEARCHLISTCATALOG
    where
        len(SEARCHLISTCATALOG.QUICKFINDFIELD) > 0;

    return 0;