now i think i am totally understood on concatenate issue . i think concatenate string using the following way is the best amoung all the above way.
Code:
   SqlQuery = "SELECT  TradingSummaryStatus.ID, TradingSummaryStatus.GROUP_NO, "
         SqlQuery = SqlQuery & " TradingSummaryStatus.YEARs,TradingSummaryStatus.CSALESLEVEL,"
         SqlQuery = SqlQuery & "TradingSummaryStatus.WEEKNO, TradingSummaryStatus.UPDATEDTIME,"
         SqlQuery = SqlQuery & " TradingSummaryStatus.STATUS, TradingSummaryStatus.BRANDID,"
         SqlQuery = SqlQuery & " TradingSummaryStatus.LVLRECDATE, TradingSummaryStatus.BRANDDETAIL"
         SqlQuery = SqlQuery & " From TradingSummaryStatus"
         SqlQuery = SqlQuery & " Where TradingSummaryStatus.Status <> 'C'"