select serial_number from t_sendfile_draft_info where serial_number like '20021203%'
此处的serial_number 是numeric 型,可是该语句就在报错,我还试了int 型,也在报错,请问一下,这个是不是sybase 的问题?这类的语句在sybase里该如何写呢?
---------------------------------------------------------------
select serial_number from t_sendfile_draft_info where convert(varchar,serial_number) like '20021203%'