select
case len(cast(dfgap as varchar(10)) )
when 5 then cast(dfgap as varchar(10))
when 4 then cast(dfgap as varchar(10))+'0'
when 3 then cast(dfgap as varchar(10))+'00'
when 2 then cast(dfgap as varchar(10))+'000'
when 1 then cast(dfgap as varchar(10))+'.000'
end as newdfgap
from tableA如題,要把此語句寫入delphi的
query1.sql.add(''); 中
想解決的問題是使dfgap字段小數點後保留三位有效數字。如果在delphi直接有此函數,請一起告訴我,在線,解決後送分!
case len(cast(dfgap as varchar(10)) )
when 5 then cast(dfgap as varchar(10))
when 4 then cast(dfgap as varchar(10))+'0'
when 3 then cast(dfgap as varchar(10))+'00'
when 2 then cast(dfgap as varchar(10))+'000'
when 1 then cast(dfgap as varchar(10))+'.000'
end as newdfgap
from tableA如題,要把此語句寫入delphi的
query1.sql.add(''); 中
想解決的問題是使dfgap字段小數點後保留三位有效數字。如果在delphi直接有此函數,請一起告訴我,在線,解決後送分!
再用case length(aaa) of
5:
command;
..
1:
commnad;
end;
就可以了,其它方法我还没想
case len(cast(dfgap as varchar(10)) )
when 5 then cast(dfgap as varchar(10))
when 4 then cast(dfgap as varchar(10))+'+'+''0''
when 3 then cast(dfgap as varchar(10))+'+'+''00''
when 2 then cast(dfgap as varchar(10))+'+'+''000''
when 1 then cast(dfgap as varchar(10))+'+'+''.000''
end as newdfgap
from tableA
');