Using apostrophe in DataTable.Select()

[Guest]

Hi,
I'm using the dataTable.Select() method in my code.
This is my code:
dft.Tables[0].Select("fieldName='" + @fieldName + "'") ;

This works fine until there is an apostrophe in the
fieldName variable - then i get error message:
"Syntax error: Missing operand after ...".

How can i use queries with apostrophe inside?

Thanks.

 

[Mark Rae]

How can i use queries with apostrophe inside?

Replace the single apostrophe with double apostrophe