'Example O'Toole' how to delimate a '

I'm sure this is a real simple one ,

whats the best trick when your select conditions have a ' in the value
"WHERE (People.FullName = 'Example O'Toole' )" ?

Chris


Example

strSQLPeople = "SELECT People.FullName "
strSQLPeople = strSQLPeople & "FROM People "
strSQLPeople = strSQLPeople & "WHERE (People.FullName = '" &
Me.ComboFullName.Value & "' ) "
strSQLPeople = strSQLPeople & "GROUP BY People.FullName "

Set rstPeople = New ADODB.Recordset
rstPeople.CursorType = adOpenStatic
rstPeople.CursorLocation = adUseClient


Debug.Print strSQLPeople

' strSQLPeople example
' SELECT People.FullName FROM People WHERE (People.FullName = 'Example
O'Toole' ) GROUP BY People.FullName

rstPeople.Open strSQLPeople , CurrentProject.Connection, adOpenKeyset,
adLockOptimistic, adCmdText

Jezebel
Sat Jun 26 06:44:50 CDT 2004

pString = "O'Toole"
"WHERE (People.FullName = ' " & pString & " ');"




"Chris Joyce" <nntp(remove)@chrisjoyce.id.au> wrote in message
news:Og9dzE1WEHA.4092@TK2MSFTNGP11.phx.gbl...
> I'm sure this is a real simple one ,
>
> whats the best trick when your select conditions have a ' in the value
> "WHERE (People.FullName = 'Example O'Toole' )" ?
>
> Chris
>
>
> Example
>
> strSQLPeople = "SELECT People.FullName "
> strSQLPeople = strSQLPeople & "FROM People "
> strSQLPeople = strSQLPeople & "WHERE (People.FullName = '" &
> Me.ComboFullName.Value & "' ) "
> strSQLPeople = strSQLPeople & "GROUP BY People.FullName "
>
> Set rstPeople = New ADODB.Recordset
> rstPeople.CursorType = adOpenStatic
> rstPeople.CursorLocation = adUseClient
>
>
> Debug.Print strSQLPeople
>
> ' strSQLPeople example
> ' SELECT People.FullName FROM People WHERE (People.FullName = 'Example
> O'Toole' ) GROUP BY People.FullName
>
> rstPeople.Open strSQLPeople , CurrentProject.Connection, adOpenKeyset,
> adLockOptimistic, adCmdText
>
>