On 7/10/16, Hakan Yüksel <[email protected]> wrote:
> Hi i detect a bug theirs result should be same but it is not
>
> select   replace( cast (1 as real)  , "." ,  "")   ,   1

The "cast(1 as real)" expression results in "1.0".  The
"replace('1.0', '.', '')" expression results in "10".  SQLite appears
to be doing the right thing here.

>
> thanks in advance...
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to