Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Rounded To The Nearest Dollar

forums › forums › SQLyog › Query Builder and Schema Designer › Rounded To The Nearest Dollar

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 24, 2010 at 3:40 pm #12167
      Diana Magers
      Member

      Hello everyone I am trying to round the balance to the nearest dollar

      I have the customer_num, customer_name ROUND(balance,0)

      from customer

      I am getting an error message:

      Msg 102, Level 15, State 1, Line 1

      Incorrect syntax near 'Balance'.

      Not sure why it is doing this.

    • November 24, 2010 at 4:14 pm #31597
      peterlaursen
      Participant

      How is this related to 'Query Builder and Schema Designer' category in this Forum?

      Please paste the complete (SELECT) statement?  You did not miss a COMMA after 'customer_name'?

      Also what client returns exactly this error:

      “Msg 102, Level 15, State 1, Line 1

      Incorrect syntax near 'Balance'.”

      .. it is not a standard MySQL server or client error.

    • November 24, 2010 at 4:17 pm #31598
      Diana Magers
      Member
      'peterlaursen' wrote:

      How is this related to 'Query Builder and Schema Designer' category in this Forum?

      Please paste the complete (SELECT) statement?  You did not miss a COMMA after 'customer_name'?

      Also what client returns exactly this error:

      “Msg 102, Level 15, State 1, Line 1

      Incorrect syntax near 'Balance'.”

      .. it is not a standard MySQL server or client error.

      Please forgive me I clearly mis-post. I actually got the answer worked out. Thank you again. Diana Magers

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.