Results 1 to 2 of 2

Thread: SQL: Quotes around the values of numeric columns?

  1. #1
    Join Date
    Mar 2009
    Posts
    1

    SQL: Quotes around the values of numeric columns?

    Hello,

    I must modify an application build with MySQL to make it work with other databases.

    This application works perfectly but use quotes in all the requests even for numeric columns.

    For example:
    SELECT * FROM table WHERE id='1'

    (where id is declared as INTEGER)

    Does Sybase accepts this syntax?

  2. #2
    Join Date
    Dec 2007
    Posts
    7
    You'll have to use the convert function

Posting Permissions

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