
SELECT * FROM V_HISMINSA WHERE (COD_ITEM BETWEEN 'C530'AND'C539'AND TIP_DIAG='D')  -- 305 
SELECT COUNT(COD_ITEM)AS JS FROM HTEMP WHERE(COD_ITEM BETWEEN 'C530'AND 'C539'AND TIP_DIAG='D')

SELECT * FROM V_HISMINSA  WHERE COD_ITEM LIKE 'C50[0-9]' AND TIP_DIAG='D' -- 311

SELECT  * FROM V_HISMINSA WHERE(COD_ITEM LIKE 'C4[3-4]_' AND TIP_DIAG='D')

SELECT * FROM V_HISMINSA  WHERE(COD_ITEM BETWEEN 'C160'AND'C169'AND TIP_DIAG='D') -- 317

SELECT * FROM V_HISMINSA  WHERE(COD_ITEM='C61X'AND TIP_DIAG='D') -- 323

SELECT * FROM V_HISMINSA WHERE(COD_ITEM BETWEEN 'C340'AND'C349'AND TIP_DIAG='D') -- 329
SELECT * FROM V_HISMINSA WHERE(COD_ITEM='C61X'AND TIP_DIAG='D')

 SELECT * FROM V_HISMINSA WHERE(COD_ITEM BETWEEN 'C340'AND'C349'AND TIP_DIAG='D') --335 


 SELECT  * FROM V_HISMINSA WHERE( COD_ITEM BETWEEN 'C180'AND'C189' OR COD_ITEM IN('C19X','C20X') )AND TIP_DIAG='D' --341 

 347 
 353 
 359 
