Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: Cast issue -varchar to int

    I am trying to execute a query utilizing CAST but can't seem to see where my syntax is incorrect, any help would be appreciated.

    select * from mygtp.registry a, mygtp.tv3_common_message b where (cast(a.MSG_STORE_ID as int) >= cast('1234' as int) and a.ticket_id=b.BUSINESS_TRANSACTION_ID

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Check your parenthesis. Also why are you casting a literal?

    Andy

Posting Permissions

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