where后面的条件可以用模糊变量吗?

发布网友发布时间：2022-12-05 02:34

共2个回答

热心网友时间：2024-01-08 22:43

1) where ADCP"DEPARTMENT like which_department. For a dynamic where clause, it should be written like DATA a_where type string. concatenate 'ADCP"DEPARTMENT like' which_department into a_where separated by space. select ... ?from ... ?where (a_where). 2) string不能直接加呀. Yes you can. But using '&' instead of ?'+'. A restriction is that only the literal strings can be used

热心网友时间：2024-01-08 22:43

晕. string不能直接加呀. CONCATENATE '%' which_department '%' into which_department.

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com