sql query with apostrophe

Hi,

I am facing a probleam in SQLGridSelectedView from dotnetnuke, If I type O'Connell in my LastName Textbox I coudn't get the detail but if I type Connell than I'll get all the details.

For Example :
First Name = Daniel
Last Name = O'Connell


SQL Statement(SELECT or EXEC Only): SELECT LastName AS [Last Name], FirstName AS [First Name],Office AS Location, Department, Phone, ''+WindowsEmailAddress+'' AS Email FROM crestron_directory WHERE (LastName IS NOT NULL AND LastName <> '') AND (FirstName IS NOT NULL AND FirstName <> '') AND (((WindowsEmailAddress <> 'gfeldstein@crestron.com') AND (WindowsEmailAddress <> 'lfeldstein@crestron.com') AND (WindowsEmailAddress <> '') AND (WindowsEmailAddress is not null)))


Text Search
Search Clause: (LastName LIKE '%[Search2:Text]%')


I have tried
-(LastName LIKE '% ''[Search2:Text]%')
-(LastName LIKE '% '''[Search2:Text]%')
-(LastName LIKE '% \'[Search2:Text]%')
-(LastName LIKE '% ''[Search2:Text]%')
-(LastName LIKE '%" + [Search2:Text] + "%')
-(LastName LIKE '%" + [Search2:Text] + "%'

")


Thank you

Tags: Dotnet nuke