Hi,

You just have to double up the ' as in

select * from test where data = 'O''Connor'

If you are creating the statement dynamically from say a web page you...

Hi,

I generally stick to the 'fully normalised' solution if there is any doubt as it provides the most flexibility regarding how the data will be used.  if you create a...

Don't drop the index!

If SQl server is ising it then it must be of use.

The most likly reason is that the query only requires these three columns form the table....

Yes you can do this but It isn't very efficient so you should take care where you use it.

Example:

Select a.col1, b.col1, etc...

from TableA a

join TableB b

on a.col1 like '%' + b.col1...