Either 'Murang''a' or 'Murang\'a' should do it. But if you inserting from an app, use parameterized queries. On Mon, Sep 20, 2010 at 11:03 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Techies, How do we insert words like 'Murang'a' in mssql as it will be seen as an unclosed quote Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards Brian Ngure