searching in SQL Report
I have a single seach parameter (LastFirst) in a SQL Report. I have a student with an ' in the middle of their name (D'Arcy). How can I get my report to find this student as it does not seem to like the ' in the middle of the name Thanks, Debra
February 15th, 2012 9:50pm

Hi, try this SELECT * FROM tablename WHERE name LIKE '%''%' Hope this will help you !!! Sanjeewan
Free Windows Admin Tool Kit Click here and download it now
February 15th, 2012 10:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics