By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

mysql

P: 1
how to convert a string say 'k30' into an integer. I just need 30 as an integer. I've done substr('k30',2,3) but that returns a string and I want it in number format. Please help.
Dec 29 '11 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
Use the convert function to change data types.
Dec 29 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.