适应症字段截取长度

admin

1. SELECT  <font color="#ff0000">a.drugid,a.drugname,to_char(a.spec),a.enterprisename,</font>
   
2.     CASE
   
3.         WHEN Length(<font color="#ff0000">a.feature</font>)> 2000 THEN to_char(SUBSTR(<font color="#ff0000">a.feature</font>, 1, 2000))
   
4.         ELSE to_char(<font color="#ff0000">a.feature</font>)
   
5.     END AS 适应症
   
6. FROM
   
7.     <font color="#ff0000">drugspec.instructions_list</font> a;
   

复制代码