[wango]

How do I handle a name like "D'Unger" with an apostrophe in it as in O'Neill". I am using SQL and C/C++ to input migrate data from one database to another. i am runing into trouble everytiome I bump into name like "D'Unger". What is the solution?

// 11.16.2002 modified
strcpy((char *) SQLStmt, "SELECT * FROM IPM_FROM_PADDINGTON.dbo.Personnel WHERE ");
strcat((char *) SQLStmt, "FName = '");
strcat((char *) SQLStmt, visa1elements.rowElem1_Stg_First_Name);
strcat((char *) SQLStmt, "' AND LName = '");
strcat((char *) SQLStmt, visa1elements.rowElem1_Stg_Last_Name);
strcat((char *) SQLStmt, "'");

[coderitr]

Double the single quote character in the select statement. That will require some creative editing of the string but the way it should look in the SQL is D''Unger