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