如果有一個程序是這樣：(PB的源代碼)
IF NOT IsNull(ld_from_date) AND NOT IsNull(ld_date) THEN
 ls_sql_where = ls_sql_where + &
 " Trunc(~"CITYNET_INTERFACE~".~"REQUESTED_PICKUP_DTM~") between TO_DATE('" + &
 String(ld_from_date, 'dd/mm/yyyy') + &
 "', 'dd/mm/yyyy') and TO_DATE('" + &
 String(ld_date, 'dd/mm/yyyy') + "', 'dd/mm/yyyy')" + " AND "
 ls_query_criteria = ls_query_criteria + " Trip Date between " + String(ld_from_date,'DD/MM/YYYY') + &
  " AND " + String(ld_date,'DD/MM/YYYY')
END IF

IF NOT IsNull(ld_from_date) AND IsNull(ld_date) THEN
 ls_sql_where = ls_sql_where + &
 " Trunc(~"CITYNET_INTERFACE~".~"REQUESTED_PICKUP_DTM~") >= TO_DATE('" + &
 String(ld_from_date, 'dd/mm/yyyy') + "', 'dd/mm/yyyy')" + " AND "
 ls_query_criteria = ls_query_criteria + " Trip Date >= " + String(ld_from_date,'DD/MM/YYYY')
END IF

IF IsNull(ld_from_date) AND NOT IsNull(ld_date) THEN
 ls_sql_where = ls_sql_where + &
 " Trunc(~"CITYNET_INTERFACE~".~"REQUESTED_PICKUP_DTM~") <= TO_DATE('" + &
 String(ld_date, 'dd/mm/yyyy') + "', 'dd/mm/yyyy')" + " AND "
 ls_query_criteria = ls_query_criteria + " Trip Date <= " + String(ld_date,'DD/MM/YYYY')
END IF
把上面的代碼用SQL的查詢語句來實行。
這時我用到了一個between運算符，這個運算符會包括它后的兩個入參：
如：select table.A from table where table.A between 5 and 10.也就是說這時的條件A>=5 and A<= 10的記錄。