Convert text to integer

[#1]

Hello folks.

I'm trying to create a new field for counting unique people in our db. I'm concatenating First Name, Last Name, Carrier, and Birth date.

First Name, Last Name and Carrier are all text fields, and would like to get the numerical value for those fields.

Is this possible?

[#2 · Accepted solution]

Hi,

quick shot: try autonumber (see QV Help File for more information).

Rainer

[#3]

Yes it is possible. The function you are looking for is autonumberhash128(expression {, expression})

or autonumberhash256(expression {, expression}) (which is for a larger number of combinations).

See page 413-415 in the Reference Manual

[#4]

Works great. Thanks for the help guys.