At 14:12 -0500 11/23/04, Jerry Swanson wrote:
I need to make query that adds numbers. The fields are varchar format
so I have some value 12121 and some values 121212,121212.

I think I need string replace function that replace comma. What
function can do this?

It's called REPLACE().

http://dev.mysql.com/doc/mysql/en/String_functions.html

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to