Hi all,

Can any one offer some assistances in converting ASP(VB) to ASP.NET(C#).

I have a function that I would use when doing a "search" in ASP(VB) but like most I am trying to make the leap from ASP to ASP.NET.

Any help in converting the below function would be greatly appreciated.

-------------------------------------------
Public Function Search(a)
SQL = "SELECT * FROM Articles WHERE"
Dim words
For Each words In Split(a, " ")
If Len(Trim(words)) > 0 Then SQL = SQL & " ArticleTitle LIKE '%" & words & "%' OR ArticleKeywords LIKE '%" & words & "%' AND "
Next
SQL = Mid(SQL, 1, Len(SQL) - 5)
End Function

Call Search(Request.QueryString("fsearch"))
-------------------------------------------

Thanks.

Kind Regards,
Tarran Walker
tarran.walker@milkit.net