急->SQL 如何查在某一范的字符串


DB
table: t1字段如下
productid productDate productName
00001-00002 2009-01-01 A
00001-00003
00002-00001
00002-00002
00002-00004
00002-00005

在想查varchar型的productid在00002-00002到00002-00005的,
SQL句的between如何,教






[解决办法]

SQL code

--TRYWHERE CAST(REPLACE(productid,'-',0) AS INT) BETWEEN 2000002 AND 2000005