Database Reference
In-Depth Information
Itisinterestingtonotethattheapproachframedinthisrecipeisnotlimitedtocases
wherewehaveadelimitedfield.Thisapproachcanprovidearelativelygenericsolu-
tiontotheproblemofnormalizingflatfiles.Forexample,ifwehaveacasewherewe
havemultiplefieldstorepresentrelationalinfo,suchas
label1
,
label2
,
label3
,
orsimilarmultipleattributenamestoasinglerecord,wecanwriteasimplequeryto
concatenate them together before feeding that info into our query.