Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    12

    Unanswered: Conversion of String to int

    I converted a string value to int

    CAST(TestSth3.Emp_Code AS int)
    it returns 1,234 but i need 1234

    i am using vb.net 2008.

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is the conversion happening in SQL or in the Crystal Report itself?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    CAST(TestSth3.Emp_Code AS int) actually returns 0x000004D2, which Crystal Reports displays as '1,234' under the current display mask. Change the mask in your report, and that will change the display.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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