javascript - Best approach to remove special characters using ColdFusion and Microsoft SQL? -

i want remove special characters (",/{}etc.) input field beingness saved string db.

what best approach?

should check tackled js, coldfusion or microsoft sql - maybe three?

how go coding using coldfusion or microsoft sql?

you mean not alphanumeric?

i'd utilize rereplace in info layer.

<cfqueryparam cfsqltype="cf_sql_varchar" value="#rereplace(myvar,"[^0-9a-za-z ]","","all")#" />

update: changed include "space".

javascript sql coldfusion

Five