>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
By the way, in VFP it is not a good idea to use variable-sized fields in a SELECT statement; VFP might choose a field without data to determine the total field length for the (fixed-size) result. You have to move spaces to the end, for example:
select ..., padr(alltrim(Field2) + "-" + alltrim(Field3), 30), ...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)