String Function to replace [ ]

[seanybravo]

I have to create a function to put escape characters in to make an SQL query to work for example Sean[0] has to be preseted Sean[[]0[]] to work.

I am having problems getting my string convert funtion to work with Replace does anyone have any ideas on how to do this. I just cant seam to get my head around string manipulation. I am using ASP VBScript.

Thanks for any suggestions.

 

[tsuji]

Basic idea is to avoid explosion of square brackets.
[tt]
s="Sean[0]"
s=replace(s,"[","<[>")
s=replace(s,"]","<]>")
s=replace(s,"<","[")
s=replace(s,">","]")
[/tt]
"<" or ">" should be chosen according to cases. Basic is to avoid collision of character inside s. Choose some exotic characters (or combination of characters) at their places if deemed necessary.