MySQL Forums
Forum List  »  Stored Procedures

Convert varchar to int/ decimal?
Posted by: Andy Piro
Date: November 14, 2005 07:05PM

I need to convert some varchar data like '19.45' etc to a decimal in a query, have some other cases where I want to convert to ints. The convert() function seems to only be able to convert to char/ varchar. Am I missing something?

Options: ReplyQuote


Subject
Views
Written By
Posted
Convert varchar to int/ decimal?
49817
November 14, 2005 07:05PM
127687
November 14, 2005 07:46PM
23901
November 16, 2005 01:24PM
20395
November 16, 2005 01:52PM
19397
November 16, 2005 03:40PM
5393
June 08, 2006 05:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.