Hello. I am having trouble with a select statement in my code. The select has actually been working for months and then all of a sudden I got a surprise. One of the pieces of data has a single quote imbedded in it and it causes the lookup to fail. Here is the problem.
SELECT * FROM [Training Request Table] Where [Student Last Name]= 'Morel-à-l'Huissier' and [Student First Name]= 'Patrick' ;
As you can see the student last name has a single quote in it which messes up the select. Any ideas?????
Kevin ....
SELECT * FROM [Training Request Table] Where [Student Last Name]= 'Morel-à-l'Huissier' and [Student First Name]= 'Patrick' ;
As you can see the student last name has a single quote in it which messes up the select. Any ideas?????
Kevin ....
Last edited: