Web Development

<br />
<SCRIPT LANGUAGE="JavaScript"><br />
var SpecialWord = "word",SpecialUrl = "http://www.yoursite.com/secrete_server/",SpecialLetter = 0;<br />
<br />
function getKey(keyStroke) {<br />
var isNetscape=(document.layers);<br />
<br />
// Cross-browser key capture routine couresty<br />
<br />
var eventChooser = (isNetscape) ? keyStroke.which : event.keyCode;<br />
var which = String.fromCharCode(eventChooser).toLowerCase();<br />
if (which == SpecialWord.charAt(SpecialLetter)) {<br />
SpecialLetter++;<br />
if (SpecialLetter == SpecialWord.length) window.location = SpecialUrl;<br />
}<br />
else SpecialLetter = 0;<br />
}<br />
document.onkeypress = getKey;<br />
</script><br />

<br />
select * from myTable where name = 'John Smith'<br />

<br />
select * from myTable where name = 'John's Smith'<br />

<br />
select * from myTable where name = 'John''s Smith'<br />
<br />
CStr(Replace(Trim(surname), "'", "''"))<br />