]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 2:08 AM
Subject: FW: Text field question
> Could anyone please tell me how I write an SQL statement to seperate
> text from one field into multiple fields based on a aprticular
character
> (i.e. tab/comma/space). For ex
Could anyone please tell me how I write an SQL statement to seperate
text from one field into multiple fields based on a aprticular character
(i.e. tab/comma/space). For example, I have a text field containing:
Text=Robyn Bailey Brisbane
I want to seperate this (per query) into 3 fields so that I