Large number field in GM

[JohnnyL]

Hi,

On our SQL-based Goldmine system we have a user-defined field called UFNTURNOVR which is varchar(20) and has been used to store turnover values (pretty much in free text). I've gone through the process of tidying these values into 'numbers' eg replacing '2mil' with '2000000'.

To enable us to sort better on the proper turnover values I need to convert the field type to numeric, but all the numeric data types seem to have a maximum length of 8. I know that we have some contacts where the turnover is 100million or over which is 9 digits.

Any ideas how I can have a numeric field of 10 characters?

Thanks in advance for any help or advice.
John

 

[DJHunt]

You could pretend 0's to this field and they would sort properly.

Unless I'm mistaken a Numeric field can be 16 characters minus the decimal places which could be 0.

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- The Hacker's Guide to GoldMine Premium
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US/Default.html

 

[philhege]

The integer type (if you're not concerned with decimal places) holds values to +/-2,147,483,647. Bigint goes to over 9 * 10[sup]18[/sup].

It's been a while since I've worked with GM, but are either of these data types available in the interface?

-------++NO CARRIER++-------

 

[DJHunt]

No. In GoldMine you have but three choices, Character, Numeric, and Date.

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- The Hacker's Guide to GoldMine Premium
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US/Default.html

 

[philhege]

Yeah, I haven't dealt with it in about three years, so the memory fades.

-------++NO CARRIER++-------