someone has function to clean string before update

<i><b>Originally posted by : Ger van der Peet (gcm.vander.peet@quicknet.nl)</b></i><br /><br />I have seen various questions about sending strings to a database using formatted SQL that have single quotes in them. Some valuable links and examples were given, but I have the same problem more in general when I have an MSaccess or SQL server database with a memo field and it must be possible to use single and double quotes, & character and <CR><LF> characters. Use of these chars generate al kind of different failures. <br /><br />Although I know it's not to difficult to make something to strip all these characters, it is easier to use something someone else made. So finally the question: Is there someone out there that has written a standard function that does clean a string completely from all these characters?<br /><br />Thanks,<br /><br />Ger