1,195
社区成员
发帖
与我相关
我的任务
分享存储过程当中如何得到字符串的长度?
我在实现一个最长匹配的存储过程,里面的getlen该用哪个库函数替换
bnwxf@etang.com
...
define finded_num char(19);
let finded_num = null;
foreach
select number into number_h from tbl_group where group_id = **
let number_h = number_h||'%'
if cli like number_h then
do something
if getlen(finded_num) < getlen(number_h) then
let finded_num = number_h
end if
end if
end foreach;
bnwxf@etang.com
...
define finded_num char(19);
let finded_num = null;
foreach
select number into number_h from tbl_group where group_id = **
let number_h = number_h||'%'
if cli like number_h then
do something
if getlen(finded_num) < getlen(number_h) then
let finded_num = number_h
end if
end if
end foreach;
...全文
