/*-----查找車速小於60KM/H的車輛--------*/
------------------------------------------------------------------
SELECT dbo.HPHM1.HPHM AS 車牌頭,
dbo.WZCL.HPHM2 AS 車牌號碼,
dbo.HPHM3.HPHM AS 車牌顔色,
dbo.WZCL.RQ AS 違法日期,
dbo.WZCL.SM AS 說明,
CAST(SUBSTRING(dbo.WZCL.SM, 9, 3) AS VARCHAR) AS 行駛速度
FROM dbo.WZCL INNER JOIN
dbo.HPHM1 ON dbo.WZCL.HPHMID1 = dbo.HPHM1.HPHMID INNER JOIN
dbo.HPHM3 ON dbo.WZCL.HPHMID3 = dbo.HPHM3.HPHMID
WHERE (dbo.WZCL.WZ = '02')
AND
(CAST(SUBSTRING(dbo.WZCL.SM, 9, 3) AS VARCHAR) < '060')
-------------------------------------------------------------------