Home>Network programming tutorial>ASP tutorial

asp format like string in sql

Author：Eve Cole Update Time：2025-04-19 04:16:01

<%

'*********************************

'Function: formatQueryStr(str)

'Arguments: str, SQL statement

'Author: Alixi

'Date: 2007/7/13

'Description: Format like string in sql

'Example: <%=formatQueryStr(str)%>

'*********************************

functionformatQueryStr(str)

dimnstr

nstr=str

nstr=replace(nstr,chr(0),"")

nstr=replace(nstr,"'","''")

nstr=replace(nstr,"[","[[]")

nstr=replace(nstr,"%","[%]")

formatQueryStr=nstr

endfunction

%>

Articles that may be of interest to you:

Comparing the charindex/patindex/like problem in sqlserver, super powerful killing! ! ! Another way to write like in SQL to replace Like statements in SQL detailed analysis of the usage of like in SQL statements
Related Articles