View Full Version : Query Help!!!


marvin67
08-04-2004, 05:22 PM
How can i break a text field that contains a name where each character in the name is will be on another field.

eg: Firstname
Marvin
will become

F1 | F2 | F3 | F4 | F5 | F6 | F7
M | a | r | v | i | n |

Thanks

WayneRyan
08-04-2004, 06:22 PM
Marvin,

Expr1: Mid([SomeField], 1, 1)
Expr2: Mid([SomeField], 2, 1)
Expr3: Mid([SomeField], 3, 1) ...

But, Why?

Wayne