Change text to a number

[woodyinoz]

Hi all,

For the purposes of sorting, I want to change a text field into a number field so that 10000 will come out after 12000 in ascending order.

How can I do this? I've tried just changing the field properties but that, obviously, doesn't work....

Any ideas?

Thanks in advance,

Woody

 

[woodyinoz]

It's ok! I've worked it out! For all of you that are interested I used:

CAST(<Column Name> AS smallint)

Cheers,

Woody