ADOQUERY1.SQL.Add('SELECT * FROM RYMXA WHERE SUBSTRING(DWDM,1,:A)=''301'''); ADOQUERY1.Parameters.ParamByName('A').Value:=4; ADOQUERY1.Open 错误提示：’函数susbtring参数3的数据类型VARCHAR无效‘不知为什么SUBSTRING函数如何传递数值变量。

Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...