With Warm Regards =============== Atul Setu +91-98112-20302 +91-95558-00788 [email protected]
On Sat, Dec 26, 2009 at 12:59 PM, nag <[email protected]> wrote: > hi friend im getting following error,wen i run > DropDownList1_OnSelectedIndexChanged event > > Line 1: Incorrect syntax near 's'. > Unclosed quotation mark before the character string ' '. > > here is my query > please help me to solve this > > Select a.Category_Id, > a.Category_Name,b.umc,b.Magazine_Name,Magazine_Description From > [magazine_category] a Inner Join magazine b on a.Category_Id = > b.Category_Id and a.Category_Name = 'Men'*s Interest'* > the red mark is error point. 'Men' is a string and the rest is wat. Please give this as '*Mens Interest*' or you can use *Escape Characters for that *
