如果有一個(gè)程序是這樣：(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的查詢語(yǔ)句來(lái)實(shí)行。
這時(shí)我用到了一個(gè)between運(yùn)算符，這個(gè)運(yùn)算符會(huì)包括它后的兩個(gè)入?yún)ⅲ?BR>如：select table.A from table where table.A between 5 and 10.也就是說(shuō)這時(shí)的條件A>=5 and A<= 10的記錄。