Concatenating an input variable to another input variable

SqlBase and Centura Solutions
NBVC

Concatenating an input variable to another input variable

Post by NBVC » 12 Mar 2010, 11:54

Hi,

I have to input variables, one for city, one for zip code.

What do I need to do in order to make these free flow instead of static in position.

E.g. I want to be able to "concatenate" the zipcode to the end of the city and with a comma in between... so whatever length the city string is, the comma and zipcode will append to the end..

Thanks.

NBVC

Re: Concatenating an input variable to another input variable

Post by NBVC » 12 Mar 2010, 12:34

I think I have figured it out...

Use the || symbol  

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 463
Joined: 05 Mar 2017, 20:57
Location: Stroud, England <--> Tauranga, New Zealand

Re: Concatenating an input variable to another input variable

Post by Steve Leighton » 17 Mar 2010, 16:08

Use City || ' , ' || Zip

either in a formula or direct on the form
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

Return to “TekTips”

Who is online

Users browsing this forum: [Ccbot] and 0 guests