Hi,
Check this....
Select ISNULL(COUNTRY,'') + '->' + ISNULL(STATE,'') + '->' + ISNULL(CITY,'') As Addr from your table
or
Select
CASE WHEN ISNULL(COUNTRY,'')='' THEN '' ELSE COUNTRY END +
CASE WHEN ISNULL(STATE,'')='' THEN '' ELSE + '->' + STATE END +
CASE WHEN ISNULL(CITY,'')='' THEN '' ELSE + '->' + CITY END
As Addr from your table
Hope this will help you.
Cheers