Case Statement Help 1

[sila]

Hi

Based on the sql statement below how do I get the address fields to show N/A when the ShowAddress field is 0?

ALTER PROCEDURE dbo.CES_MEMSelectMemberIDAddress

	(
		@MemberID as varchar(10)
	)

AS
	/* SET NOCOUNT ON */
	 SELECT     Address1, Address2, Address3, Address4, Postcode, Telephone, OfficeTelephone, Email, Fax, OfficeFax, Website, ShowAddress, Mobile
	 FROM         dbo.Members
	 WHERE     (UserID = @MemberID)
RETURN

Thanks.

 

[JamesLean]

SELECT
  CASE WHEN showaddress = 0 THEN 'n/a' ELSE adddress1 END AS address1,
  CASE WHEN showaddress = 0 THEN 'n/a' ELSE adddress2 END AS address2,
  ...
FROM dbo.members
WHERE userid = @memberid

--James