sybase里的like 如何处理numeric类型的字段?

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%'

Published At
Categories with 数据库类
comments powered by Disqus