? to insert values with ' (single quote)

<i><b>Originally posted by : Ravi (ravichandrantv@hotmail.com)</b></i><br />Hi friends,<br />How to insert record containing single quote in Sql Server (ie)I want to insert like <br />1'st<br />2'nd<br />3'rd...etc<br />Please help me.<br /><br />

<i><b>Originally posted by : sqlman</b></i><br />replace all apostrophe's (') with two apostrophes ('')<br /><br /><br />------------<br />Ravi at 5/31/2000 8:04:38 PM<br /><br />Hi friends,<br />How to insert record containing single quote in Sql Server (ie)I want to insert like <br />1'st<br />2'nd<br />3'rd...etc<br />Please help me.<br /><br />