Re: Text field question

2003-01-20 Thread Stefan Hinz, iConnect \(Berlin\)
]> 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

FW: Text field question

2003-01-19 Thread Robyn Bailey
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