>Good morning friends,
>
>I need to change the candidate key of several tables from one field to an expression of two fields. Example: Now the candidate key is field MY_ID, C, 20. After the change the candidate key will be MY_ID + STR(MY_INT_FLD,6).
>
>Is there a better approach than to convert the Integer field to string using STR() function? Also, am I going to run into any problems with having candidate as an expression?
>
>Thank you in advance for any suggestions.
You can use BINTOC() function to convert integer to a string. You may have a composite candidate key, if needed.
If it's not broken, fix it until it is.
My Blog