SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[p_grid_usr_profils]
    @profil_code ais_code_short = '%'
AS 
    BEGIN
        SELECT  pr_profil_code ,
                pr_l1 ,
                pr_l2 ,
                pr_l3
        FROM    dbo.usr_profils
        WHERE	@profil_code = '%' OR pr_profil_code = @profil_code
    END
GO
