how to replace double quotes with single quotes

Question

Hi,

 

This is my string query :

 

strSQL = "SELECT Employeeworkhourslogid,CONVERT(VARCHAR(10),Date,101) AS 'Date', InTime = LTRIM(SUBSTRING(CONVERT(VARCHAR(20), CONVERT(DATETIME, InTime + ':' + InTimeMins ), 22), 10, 5) + RIGHT(CONVERT(VARCHAR(20), " _

& "CONVERT(DATETIME, InTime + ':' + InTimeMins ), 22), 3)), OutTime = LTRIM(SUBSTRING(CONVERT(VARCHAR(20), CONVERT(DATETIME, OutTime + ':' + OutTimeMins ), 22), 10, 5) + RIGHT(CONVERT(VARCHAR(20)," _

& " CONVERT(DATETIME, OutTime + ':' + OutTimeMins ), 22), 3)),TimeDeduction1 AS 'Duration1',Purpose1,TimeDeduction2 AS 'Duration2', Purpose2,TotalHours,Whereworked,Action,EmployerNotes AS Comments , (EGH.TotalHours * E.HourlyRate) as 'TotalAmount' FROM EmployeeGrossHours EGH inner JOIN tblEmployee E on E.EmployeeID = EGH.EmployeeID WHERE EGH.EmployeeID = " & employeeid & " AND Clientid=" & ClientID & " AND Date between """ & paidStartDate & """ And """ & paidStartDate & """"

I want to replace  """ & paidStartDate & """ And """ & paidStartDate & """" double quotes with single quotes.

 

Please give me solution.

 

Thanks.