At 09:16 PM 27/09/2006, you wrote:

>All - I have a VARCHAR field with values
>that in reality are integers - "1" or "200" etc.
>
>I need to populate an INTEGER field with these
>obviously casting along the way but it does
>not seem to work and also I cannot figure
>out how to trap for conversion errors

What size is the VARCHAR defined as, what are the max size and value
of the strings stored and what are the errors are you getting? And
are you sure your strings don't contain any leading or in-line blanks
or other alpha characters like hyphens, decimal points, dollar signs,
commas and so on?

./hb