K3 WISE Development plugin "SQL statement where query-range query/Fuzzy query"

0. Stored procedure start variable definition

@FBeginDatevarchar10),--Document Start date@FEndDatevarchar10),--Document due date. @FItemID varchar (50),  @FItemID2 50 @FCust varchar (50),  @FCust2 varchar ( 50varchar (

1. Date range Query

and t.fdate>=@FBeginDate andt.fdate<=@FEndDate='2100-01-01end 

2, Customer code range query

and T11. Fnumber>=@FCust andT11. Fnumber<=@FCust2= then(end       

3. Item Code Range Query

and T14. Fnumber>= andt14. Fnumber<=@FItemID2= then(end      

4, Document type fuzzy query

'%'++'%'      

K3 WISE Development plugin "SQL statement where query-range query/Fuzzy query"