Home | Scripting Techniques
Big Marvin This site publishes web authoring works done by Big Marvin.

Cleaning SQL Statements

This script will remove single quotes that will mess up SQL statements.

<script language=vbscript>
function cleansql(text)
for a=1 to len(text)
 b=mid(text,a,1)
 if b="'" then b=""
 c=c+b
next
cleansql=c
end function
</script>



Email me at: big_marvin@hotmail.com

1