Using "'" In a Select Statement

[Jimmer]

I know this has been asked before and I forget how to do it.
I need to know how to do a Select Statement with a ' in it.
Example:

"SELECT * FROM [CLIENTS] WHERE [NAME] = '" & name & "'"

and here name would equal Joe O'Brien.

Any help would be appreciated.

Thanks In advance

[davidrobin]

The answer is to place a second ' within the name string. Therefore O'Brien is changed to O''Brien.