>>UPDATE : I see you reached the same conclusion re: StringBuilder() :-}
>>
>>I don't think StringBuilder() will help. Regex() may be the way to go. Maybe Gregory, who has that off pat, will chip in - it's not my strong point :-{
>
>Yes, I took a look at Regex. But, this will not be necessary. The reason I had a long string was because the parsing method parses the entire SQL string. In this case, the longest part is the WHERE IN clause, which does not need any conversion. So, what I do is to cut that off from the parsing method and add it back after. So, basically, I am only dealing with the base SQL, which never gave me any problem so far.

Out of curiosity : can you provide an example of the input string ?