Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    50

    Unanswered: question about quotes ?

    when i'insert a data with quotes into table i get the error
    something like this
    insert into table(string_field0) values(' 'test' ')

    why inserting string with quotes is a little problem ?
    this problem is in all databases ?

    only one solution is to use replace function , like
    Replace(Str," ' "," '")

  2. #2
    Join Date
    May 2004
    Posts
    125
    In MSSQL server, you have to use two quotes to insert into a table:

    insert into table
    (col1) values ('''Test''')

    DMW

Posting Permissions

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