Hi Dennis,
if you want to create a query that returns a concatenated column then:
1) choose 'Query'
'SQL Select'
2) in the 'Select Columns' box type in the columns required separated by '&'. For
example, the following code concatenates the STATE and St_Abbr columns of the
Australia tab file with a space between the entries.
State & " " & St_Abbr
Returns: Queensland QLD
You can put any text between the quotes - eg ... "/" ... returns two columns
separated by a slash.
Cheers, Russ.
[EMAIL PROTECTED] wrote:
> I'm trying to combine the data in two separate columns (both character type) of
> a single table into a single column. The data in each row varies greatly and
> can be quiet lengthy. What expresson would I use in SQL? What type of operator
> would I use? MI doesn't mention how to do this. Is it possible?
>
> Much thanks in advance,
>
> Dennis Heaney
> Verizon Wireless
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
Russell Bradford - CSIRO Division of Marine Research
GPO Box 1538 Hobart Tasmania Australia 7001
Phone: (03) 6232 5077 Fax: (03) 6232 5053
Mobile: 0412 623 228
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]