Is possible to truncate text i.e.

Burman is truncated to 3 characters i.e. Bur.

Also, whats the function for generating a random number between 0 and 9?

Cheers for help,

genx

1. Check out the Left() function.

2. Int ( Random * 10 )

Worked Great, thanks

Edited September 10, 200520 yr by Guest

I'm assuming that random number * 10 generates a random number between 0 & 9, is there anyway to make it between 1 & 9. I tried playing round with the function but i still get 0's which are no good.

Help would be great.

Hi aflgenx,

To generate a random number between 1 and 9, I suggest you use:

Int(Random * 9) + 1

:P

thanks mate, it always seems to make sense after someone tells you how to do it

Edited September 12, 200520 yr by Guest