可以看delph的帮助,里面有这个问题详细说明:
A character string, also called a string literal or string constant, consists of a quoted string, a control string, or a combination of quoted and control strings. Separators can occur only within quoted strings.
A quoted string is a sequence of up to 255 characters from the extended ASCII character set, written on one line and enclosed by apostrophes. A quoted string with nothing between the apostrophes is a null string. Two sequential apostrophes in a quoted string denote a single character, namely an apostrophe. For example,
'BORLAND' { BORLAND } //字符
'You''ll see' { You'll see } //两个'连接在一起代表字符中的一个'号.
'''' { ' } 同上.
'' { null string } //空值
' ' { a space } //一个空格
示例:
SQL语句: where usename like '%张三%'
str1 :='where ' + FieldName + ' like ' + '''%' + SearchBuffer + '%'''