Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to combine 2 different variables

Status
Not open for further replies.

noway320

MIS
Aug 12, 2010
19
0
0
US
Hello all,

I need some help about combining two variables like,
zipcode will be P_zip+P_zip4 (Here P_zip and P_zip4 are 2 different variables containing null values too.)

So, zipcode will be P_zip+P_zip4 and separated by hyphen.
e.g.
1)P_zip = 1233 P_zip4= 1563
zipcode = 1233-1563

2)P_zip = 1233 P_zip4=
zipcode = 1233-
3)P_zip = P_zip4= 1563
zipcode = -1563
4) P_zip = P_zip4=
zipcode = -

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top