How to pass Parameters with single quotes in it from vb6 to sqlserver

[romiverma]

Hi All,
how to send parameters with single quotes from vb6 to sql server2000 e.g
strFilter='wher e student_id like '21%' and '
sqlstr = "Cmsp_StudentAn alysis('" & Format(dtpFrom. Value, "mm/dd/yyyy 00:00:00") & "','" & Format(dtpTo.Va lue, "mm/dd/yyyy 23:59:59") & "','" & strFilter & "')"
connection.Exec ute sqlstr
while executing its giving error bcoz my parameter is having single quotes in it.
Plz help

[Brad Orders]

Hi romiverma

Try replacing all single quotes with two single quotes.

(eg. ' becomes '').

Hope this helps.

Brad Orders

[romiverma]

hi ! thanks it works