×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Suppose I have one PF that defines codes as follows:
CODE DEF
40 'FOO'
45 'BAR'
50 'BAZ'
. . .
and I have another PF with a field that contains zero or more of the
codes, space-delimited, e.g.
CODES
'40 45 '
'40 '
'45 50 '
'40 45 50 '
. . .
Is there a pure-SQL way to produce (in a result set, and ultimately in a
view), for each record in the second file, field that's a concatenation
of the DEFs for the record's codes, e.g.
CODES DEFS
'40 45 ' 'FOO BAR'
'40 ' 'FOO'
'45 50 ' 'FOO BAZ'
'40 45 50 ' 'FOO BAR BAZ'
. . .
???
--
JHHL
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
