Hi Tim,

This has me scratching my head. I have a table called trans_history with
numerous fields.

1 of the fields is called gl_code and is a String type 20 in length.

When I view the table the gl_code fields show correct data.

But when I run a simple query: "SELECT * FROM trans_history"

Its removing the an A character from the fields data.

For example the table shows this:

gl_code
---------
A101
A102
A101
A101
A102
Z101
R101

Run a query "SELECT * FROM trans_history" and get this:

gl_code
---------
101
102
101
101
102
Z101
R101

Where me 'A' gone? It's just removed the A's for no reason, although it
left the 'Z' and 'R'

Any ideas?

Thanks,

Phil.

IGNORE THIS POST!!! PROBLEM SOLVED