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