In SQL I can use this statement:
SELECT RTRIM(AWDES1) + ' ' + RTRIM(AWDES2) + ' ' + RTRIM(AWDES3) AS DESCRIPTION, PartNumber, BIN#
FROM Query
WHERE (DESCRIPTION = @SearchDescription...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23397...