j***y
发帖数: 882 | 1 in the Access table, it is text like
10% 99%
how to convert them into
numbers(double) in SQL
like 0.1 0.99 ?
Thanks | m******y
发帖数: 588 | 2 change data type in the table definition to double and it will convert to
number. | j***y
发帖数: 882 | 3 y i know
but need sql code to do that now
【在 m******y 的大作中提到】
: change data type in the table definition to double and it will convert to
: number.
| a*******t
发帖数: 891 | 4 cdbl(Replace("99%","%",""))/100
【在 j***y 的大作中提到】
: in the Access table, it is text like
: 10% 99%
: how to convert them into
: numbers(double) in SQL
: like 0.1 0.99 ?
: Thanks
|
|
