这样的sql语句怎么实现！！！

[lanfanghelanfanghe]

exec('insert into '+@表+'(cVouchType,cVouchID,dVouchDate,cDeptCode,cCoVouchID,cOperator,cCheckMan,iID,cDwCode,cexch_name,cflag)
select io_flag,Bill_num,Bill_date,nullif(ltrim(rtrim(dept_id)),'''') ,Cor_billnum,bill_empid,Aud_Empid,ordercode ,IO_flag as my,''人民币'',''AP'' from 表2)

如果取出io_flag的值大于6 ，我就把substring(io_flag,1,5)插入目标表里
如果取出io_flag的值小于或等于6 ，我就把io_flag插入目标表里
如何解决,请大家帮忙！！

[pbsql]

exec('insert into '+@表+'(cVouchType,cVouchID,dVouchDate,cDeptCode,cCoVouchID,cOperator,cCheckMan,iID,cDwCode,cexch_name,cflag)
select case when len(io_flag)>=6 then substring(io_flag,1,5) else io_flag end,Bill_num,Bill_date,nullif(ltrim(rtrim(dept_id)),'''') ,Cor_billnum,bill_empid,Aud_Empid,ordercode ,IO_flag as my,''人民币'',''AP'' from 表2')

[xlhl]

exec('insert into '+@表+'(cVouchType,cVouchID,dVouchDate,cDeptCode,cCoVouchID,cOperator,cCheckMan,iID,cDwCode,cexch_name,cflag)
select case when io_flag>6 then substring(io_flag,1,5) else io_flag end io_flag,Bill_num,Bill_date,nullif(ltrim(rtrim(dept_id)),'''') ,Cor_billnum,bill_empid,Aud_Empid,ordercode ,IO_flag as my,''人民币'',''AP'' from 表2)

[zjcxc]

declare @表 sysname
exec('insert into '+@表+'(cVouchType,cVouchID,dVouchDate,cDeptCode,cCoVouchID,cOperator,cCheckMan,iID,cDwCode,cexch_name,cflag)
select case when io_flag>=6 then substring(io_flag,1,5) else io_flag end,Bill_num,Bill_date,nullif(ltrim(rtrim(dept_id)),'''') ,Cor_billnum,bill_empid,Aud_Empid,ordercode ,IO_flag as my,''人民币'',''AP'' from 表2')

[zjcxc]

一楼看错了吧? "如果取出io_flag的值大于6",不是len

不过,楼主要取 substring(io_flag,1,5) ,似乎又应该是 len 的理解才对

[pbsql]

我的理解是可能楼主叙述有误^_^

[lanfanghelanfanghe]

几位老兄，是我错了，呵呵！！！