在db中找到我们的字符串 [英] find our string in string in db

问题描述

大家好，

我需要在数据库列中找到字符串...并打印我的字符串(如果它存在于字符串中)

Hi all,

i need to find string in database column...and print my string if it present in string

if instr({bustruct.name},"AFS",1)<0 then
    securitytype = "AFS"
else if instr({bustruct.name},"HTM",1)<0 then
    securitytype = "HTM"

ELSE  securitytype = "HFT"

bustruct.name包含;-.


FI-RM-ITS长期
FI-RM-ITS短期
发行ITS时
FI-RM-HTM长期
FI-RM-HTM短期
何时发行HTM
FI-FC-HTM长期

等....

谢谢，
乌玛...

bustruct.name contains;--.


FI-RM-ITS Long Term
FI-RM-ITS Short Term
When Issue ITS
FI-RM-HTM Long Term
FI-RM-HTM Short Term
When Issue HTM
FI-FC-HTM Long Term

etc....

Thanks,
Uma...

推荐答案

尝试一下

if instr({bustruct.name},"AFS")>0 then
    securitytype = "AFS"
else if instr({bustruct.name},"HTM")>0 then
    securitytype = "HTM"
else
    securitytype = "HFT"

这篇关于在db中找到我们的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！