G'day Adrian,
On 2013-02-06, at 12:44 , Adrian Klaver <adrian.klaver@gmail.com> wrote:
> This one I could see if the split_part yielded an empty string.
You are right on this one - the higher level components don't have a =
split part 2. Thank you.
>=20
> What type is locationcode and could you provide an example?
Varchar an example would be 6 for level 1 field, and 6.34 for level 2.
cheers
Ben
--=20
Ben Madin
t : +61 8 6102 5535
m : +61 448 887 220
e : ben@ausvet.com.au
AusVet Animal Health Services
P.O. Box 5467
Broome WA 6725
Australia
AusVet's website: http://www.ausvet.com.au
This transmission is for the intended addressee only and is confidential =
information. If you have received this transmission in error, please =
delete it and notify the sender. The contents of this email are the =
opinion of the writer only and are not endorsed by AusVet Animal Health =
Services unless expressly stated otherwise. Although AusVet uses virus =
scanning software we do not accept liability for viruses or similar in =
any attachments. Thanks for reading.