Sql search programming question

[jorm]

OleDbCommand aCommand = new OleDbCommand("select name, start_time from programme where name like '" + stringToMatch + "%'", aConnection);

It works fine except when the string to match contains a '

any ideas?

[Jeff]

Use

OleDbCommand aCommand = new OleDbCommand("select name, start_time from programme where name like '" + stringToMatch.Replace("'","''") + "%'", aConnection);

This is what I do in the video archiver plug-in.

Jeff

[jorm]

Thank you that worked great.