mysql

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • J MJ
    New Member
    • Dec 2011
    • 1
    #1

    mysql

    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.
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      Use the convert function to change data types.

        Comment

        Previous template Next
        Working...