I was going through the CATALOG Sample and trying to figure it out.
I couldn't find out how and where the "Data Source Name" dialog is
can anyone help me out,
I have trouble with a table that I have added a full text catalog.
The problem is when I do a search for records containing an author's name
I need another way to use a ' (single quote) in my search
Example ( I am trying to select records that have the author O'Grady, M. E.
in one of the fields)
No syntax that I use works.
I have tried:
SELECT * FROM tblBooks WHERE CONTAINS(*,'"O''Grady, M. E."')
SELECT * FROM tblBooks WHERE CONTAINS(*,'"O'Grady, M. E."')
What is the correct escape sequence when your using conatins and double
quotes ( to make an exact phrase search )?
I can't find any documentation on this. Help!
Thanks in advance,
replace nospam.com with yahoo.com