Is there a way to combine two text fields in an external autofill SQL select string

[Beverly_Ehlbeck]

Looking for a simple way to combine two values from an external databse to be one keyword.

For example we have the following current SQL Select String

select pid_parcel, street1, lot_parcel, block_parcel, plan_name_parcel, dstlot_parcel, jurroll_parcel

from Parcel_To_Vadim

where pid_parcel='@primary'

and we want the 2^nd  keyword value to be the full street address which is currently contained in the external database as STREET_NUM1 + STREET_NAME.  The current value of street one is the mailing address in our databse not the physical address.

[Brian_Smith]

Hey Beverly,

This should be possible using an External Autofill Keyword Set. Can you test something like this?

select pid_parcel, RTRIM(street_num1) + ' ' + street_name, lot_parcel, block_parcel, plan_name_parcel, dstlot_parcel, jurroll_parcel

from Parcel_To_Vadim

where pid_parcel='@primary'

I added the RTRIM to remove any trailing spaces after the first column value.

Hope this helps!