>>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.
I have not used BINTOC() before. What would be advantage(s) of using it instead of STR()?
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham