1)where Oidsid1||Oidsid2||Oidsid3||Oidsid4||Oidsid5 like '%'||usrdept||'%'"
2)select Wktkey as Codkey1, Wktfrhm||'~'||Wkttohm as Coddata from THR
2)select Wktkey as Codkey1, Wktfrhm||'~'||Wkttohm as Coddata from THR
like, '%': 模糊查询,没什么好说的吧