Question

pls give me the SQL to copy and paste in order to make an nested if statement that meets the following 3 conditons. Thank you very much in advance:

如果实地的“活动编号”没有包含“/”特性,例如“1-100ZUOM1”,那么就添加了“suffix”/1,例如“1-100ZUOM1/1”。
if it already does contain a suffix like ”/1” e.g. ”1-100ZUOM1/1”, then change the last character to “2” e.g. ”1-100ZUOM1/2”
如果它已经包含像“....../2”这样的图象,例如“1-100ZUOM1/2”,那么最后的特性就改为“3”,例如“1-100ZUOM1/3”。

INSERT INTO tbl_All_workorders ( [Activity Number] ) SELECT AW.[Activity Number] FROM tbl_All_workorders AS AW;

Answer 1

考虑改变你的设计,以便把活动编号分成两栏,以便其数字出现在自己的分类栏中。这样,你的卡片更新将非常容易地保持,活动号码可以很容易地加以压缩,以展示,并可能利用世界基督教协进会。