Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Data type conversion.


    Does anyone in this forum can help me in joining two tables with one table having a field as "serial" datatype and another table having a field as "charater" datatypes.

    Thank you in advance.

    Bdhakhwa, Nepal

  2. #2
    Join Date
    Aug 2005
    The database server should convert character column to numeric column(or vice-versa) automatically using built-in casts.
    In my case it works.
    Check your character column if it contains any characters that are not valid numbers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts