菜鸟请教。。。。。。

Question

0401020020011 002 无名氏        .01 2004-01-02 12:52:48.643000000 2002 0 0
0402120020002 002 无名氏        .01 2004-02-12 12:28:36.647000000 2002 0 0
0402230020018 002 无名氏        .01 2004-02-23 12:09:08.327000000 2002 0 0
0403090020017 002 无名氏        329.00 2004-03-09 10:56:23.723000000 2002 0 0
0403290020007 002 无名氏        70.00 2004-03-29 08:34:47.843000000 2002 0 0
0404040020013 002 无名氏        .01 2004-04-04 00:33:44.720000000 2002 0 0
0404250020017 002 无名氏        .01 2004-04-25 12:53:14.793000000 2002 0 0
0406200020006 002 无名氏        .01 2004-06-20 13:02:16.577000000 2002 0 0
0408010020021 002 无名氏        .01 2004-08-01 11:45:50.620000000 2002 0 0
0408020020023 002 无名氏        .10 2004-08-02 12:02:37.020000000 2002 0 0
0408050020023 002 无名氏        .01 2004-08-05 13:29:21.717000000 2002 0 0
0408200020020 002 无名氏        .01 2004-08-20 12:28:54.700000000 2002 0 0
0408210020010 002 无名氏        .01 2004-08-21 13:31:14.087000000 2002 0 0
0408240020012 002 无名氏        .01 2004-08-24 11:28:00.403000000 2002 0 0
0409010020018 002 无名氏        .01 2004-09-01 11:43:07.730000000 2002 0 0
0409010020023 002 无名氏        .01 2004-09-01 13:01:25.137000000 2002 0 0
0409080020004 002 无名氏        .01 2004-09-08 12:13:14.817000000 2002 我想删除第一列的记录中第四位数字为8的记录，请问应该怎样写条件语句

Answer 1

delete tbalename where substring(colname,4,1)='8'

Answer 2

delete 
from tbalename 
where right(left(colname,4),1)='8'

Answer 3

delete
from tb
where substring(col , 4 , 1) = '8'

Answer 4

delete 表 where substring(字段,4,1)='8'