' Equivalent of VFP StrTran() ' expC1 String ' expC2 Search for specific character ' expC3 Replace Public Function StrTran(ByVal tcSearchIn As String, ByVal tcSearchFor As String, _ ByVal tcReplace As String) As String Dim loStringBuilder As StringBuilder = New StringBuilder(tcSearchIn) Return loStringBuilder.Replace(tcSearchFor, tcReplace).ToString() End FunctionHowever, this is usually not the case. So, a hit will require about 20 SQL Server requests, which in turn call this method for some adjustments, combined with some other application code logistic that might require it. The problem is if this is called millions of times in a short period, such as within 30 seconds or a minute, I have this "Out of memory" issue. Is there something I am missing here? I am returning a string to the caller. This is fairly simple. It is just two lines.