How to display 2 Columns of different Types as One Column in SQL Server 2008

Hi, Your problem is very likely you can not add this two field directly. use a Conversion on zip somewhat like

CONVERT(NVARCHAR(20),A.Zip)

Because when you are trying to add two fileds one is nvarchar and other is bigint. By default it tries to convert the NVARCHAR to big int and than adds this two value mathamatically instead of concatination.

So to apply concatination instead of Addtion you need to make all the values in string type ie varchar,navarchar...

SELECT 
A.Name
,A.MembershipNo
,A.NRICNo
,Convert(varchar(10)
,A.MembershipDate,103)as MembershipDate 
, Convert(varchar(10),A.MembershipExpDate,103) as MembershipExpDate
,A.MobileCode+''+A.Mobile as Mobile
, A.Email
,A.Address+ ' ' + Convert(Varchar,A.Zip) as Address
, B.Name as ProgramType
,A.PointsOnTrans 
FROM tbl_Member A, tbl_ProgramType B
 where A.MembershipType=B.ID  and A.RegDate>='2 jun 2012'