In my VFP applications, I join fields together in many of my SQL statements using a VFP table. As such:

SELECT mytable.field1, ALLTRIM(mytable.field2) + "-" + ALLTRIM(mytable.field3) AS mycolumn FROM mytable INTO CURSOR c_mycursor

Is there any way to do something like this using Asp.Net and SQL Server?

Thanks,

Jerry