How do I search for a row which has a single quote in the data For example: The query in ASP would be like Select * from table where name like 'CICI%'
It is throwing an error when the data given in single quotes is like Select * from table where name like 'CICI'S%' How can the query be modified? -- Kumar APP Blog: http://sparsham.com Twitter: http://twitter.com/thevolts Linkedin: http://www.linkedin.com/in/kumarapp Mobile: +91 9243089554 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx -~----------~----~----~----~------~----~------~--~---
