Posted by www.ciquery.com on 12/13/06 13:26

Try it with VARCHAR , which accepts numbers and string

--

Jack
___________________________________
Post IT Jobs for FREE - www.ciquery.com
Over 14,000 registered IT focused individuals


"Marko" <nortel@planet.nl> wrote in message
news:1166012891.128359.186250@16g2000cwy.googlegroups.com...
> Hello all,
>
> I hope someone can help me; if got a value in a cell (040 1234567),
> when I run a query
> in the Analyser I got as respons only 40 1234567, so missing the zero
> (0) not the whole number is displayed. When I run a query on a cell
> with value 1234567 I received the number 1234567 and that's oke. The
> Data Type of the Column is Char.
>
> Thanks,
>
> Marko
>

[Back to original message]