I am accustomed to building a Sql command in VFP like follows:

text to lcSql textmerge
select <<lcfields>> from <<lcTable>> where <<lcwhere>  
endtext

I wonder what are the ways which a SQL command can be constructed in VB.Net besides string concatenation.

Thanks

Glenn