CFLib.org – Common Function Library Project

Description:
A visitor may enter wildcard characters into a search string without realising. An invalid search string can then produce either a database error or odd results. This is a particular problem with double-byte languages like Japanese where a [ for example may be hidden inside a character.

Return Values:
Returns a string.

Example:

"98.3%" becomes "<cfoutput>#SQLServerPatternMatchingFormat("98.3%")#</cfoutput>"

Parameters:

Full UDF Source:

/**
 * Strip pattern-matching wildcards from a string appearing in a SQL Server query.
 * 
 * @param string      String to format. (Required)
 * @return Returns a string. 
 * @author Matthew Walker (matthew@cabbagetree.co.nz) 
 * @version 1, August 15, 2002 
 */
function SQLServerPatternMatchingFormat(string) {
    return ReplaceList(string, "[,%,_", "[[],[%],[_]");
}