Xabse - convert varchar to numeric

  • hello,

     

    i want to convert a variable that is in format varchar separate with :

    exemple (16:00)

    to convert to 16:00 numeric with : separate

    how can i do that?

     

  • '16:00' is not a valid numeric value, so you cannot do this. What are you trying to do?


  • I have a variable with this format C(5) wish is separate with :  like a time format 16:00...

    the destination variable is numeric  N(5) wish is separate with : like a time format 16:00...

    i want do do this below

    Replace fi.u_hfim With  m_sel2.horaf

    ho can do this in xbase?

  • the error is Data type mismatch.

  • You're in a SQL Server forum, not XBase. There may be people here who can help you, but you may be better off finding a forum dedicated to XBase.


  • thank you

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply