Stuart McLachlan
stuart at lexacorp.com.pg
Fri Mar 28 06:05:09 CST 2003
> Warning: Late at night AND OTTMH! :D > > SELECT CSZ: Left(YourField,Left(YourField,Instr(1,YourField,"/")-1), > Country: Right(YourField,(Len(YourField) - Instr(1,YourField,"/"))) > FROM SomeTable > Or more simply: SELECT CSZ: Left(YourField,Instr(YourField,"/")-1), Country: Mid(YourField,InstYourField,"/")+1) FROM SomeTable -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.