window.repositoryObject = {"parameters_custom_fields":[],"object_id":"f372","name":"FN_GET_BRAND_INITIAL","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"FN_GET_BRAND_INITIAL"},{"field":"Type","value":"Function"}],"script":"BEGIN\r\n\r\n\tDECLARE O_RET_VALUE VARCHAR(50);\r\n\r\n\tSELECT\tCASE WHEN I_BRAND_GROUP_NM rlike '^(a|A)' THEN 'A'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(b|B)' THEN 'B'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(c|C)' THEN 'C'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(d|D)' THEN 'D'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(e|E)' THEN 'E'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(f|F)' THEN 'F'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(g|G)' THEN 'G'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(h|H)' THEN 'H'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(i|I)' THEN 'I'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(j|J)' THEN 'J'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(k|K)' THEN 'K'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(l|L)' THEN 'L'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(m|M)' THEN 'M'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(n|N)' THEN 'N'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(o|O)' THEN 'O'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(p|P)' THEN 'P'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(q|Q)' THEN 'Q'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(r|R)' THEN 'R'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(s|S)' THEN 'S'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(t|T)' THEN 'T'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(u|U)' THEN 'U'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(v|V)' THEN 'V'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(w|W)' THEN 'W'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(x|X)' THEN 'X'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(y|Y)' THEN 'Y'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(z|Z)' THEN 'Z'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㄱ|ㄲ)' or (I_BRAND_GROUP_NM >= '가'  and I_BRAND_GROUP_NM < '나') THEN 'ㄱ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㄴ)'   or (I_BRAND_GROUP_NM >= '나'  and I_BRAND_GROUP_NM < '다') THEN 'ㄴ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㄷ|ㄸ)' or (I_BRAND_GROUP_NM >= '다'  and I_BRAND_GROUP_NM < '라') THEN 'ㄷ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㄹ)'   or (I_BRAND_GROUP_NM >= '라'  and I_BRAND_GROUP_NM < '마') THEN 'ㄹ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅁ)'   or (I_BRAND_GROUP_NM >= '마'  and I_BRAND_GROUP_NM < '바') THEN 'ㅁ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅂ)'   or (I_BRAND_GROUP_NM >= '바'  and I_BRAND_GROUP_NM < '사') THEN 'ㅂ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅅ|ㅆ)' or (I_BRAND_GROUP_NM >= '사'  and I_BRAND_GROUP_NM < '아') THEN 'ㅅ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅇ)'   or (I_BRAND_GROUP_NM >= '아'  and I_BRAND_GROUP_NM < '자') THEN 'ㅇ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅈ|ㅉ)' or (I_BRAND_GROUP_NM >= '자'  and I_BRAND_GROUP_NM < '차') THEN 'ㅈ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅊ)'   or (I_BRAND_GROUP_NM >= '차'  and I_BRAND_GROUP_NM < '카') THEN 'ㅊ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅋ)'   or (I_BRAND_GROUP_NM >= '카'  and I_BRAND_GROUP_NM < '타') THEN 'ㅋ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅌ)'   or (I_BRAND_GROUP_NM >= '타'  and I_BRAND_GROUP_NM < '파') THEN 'ㅌ'\r\n\t\t\t WHEN I_BRAND_GROUP_NM rlike '^(ㅍ)'   or (I_BRAND_GROUP_NM >= '파'  and I_BRAND_GROUP_NM < '하') THEN 'ㅍ'\r\n\t\t     WHEN I_BRAND_GROUP_NM rlike '^(ㅎ)'   or (I_BRAND_GROUP_NM >= '하'  ) THEN 'ㅎ'\r\n\t\tELSE 'ETC' END AS ddd\r\n\t\tINTO   O_RET_VALUE\r\n\t\t;\r\n\r\n\tRETURN O_RET_VALUE;\r\n\r\nEND","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"varchar(50)","custom_fields":{}},{"name":"I_BRAND_GROUP_NM","description":null,"mode":"IN","data_type":"varchar(50)","custom_fields":{}}],"dependencies":null,"imported_at":"2021-11-11 16:37"};