MICROS  |  20.04.2026

CREATE FUNCTION "custom"."GetCondMemSeq"( @condGrpSeq varchar(3) )
RETURNS integer

BEGIN
                DECLARE @rslt integer;
    DECLARE @sqlStr varchar(2000);
    Declare @tmpGrpSeq varchar(3);
    set @tmpGrpSeq = @condGrpSeq;
    if LENGTH (@tmpGrpSeq)=1 then
        set @tmpGrpSeq = '0'+ @tmpGrpSeq;
    end if;

    set @sqlStr='SELECT top 1 cond_grp_mem_seq into @rslt FROM micros.cond_grp_mem_def where ob_cond_grp_'+ @tmpGrpSeq +'_mem=''T'' '; 
    
    execute (@sqlStr);
                
    RETURN @rslt

END;