I have case numbers from 2 different systems that I'm trying to compare. The case numbers can be different in a different format in both systems, but if I break them down, I should be able to do a good comparison. In one system, each portion of the case number is concatenated from several fields:
cs_cat(string) ex. GV
cs_id_yr (number) ex. 91
cs_num (number) ex. 123456
Then I join these together using:
{fcs_cs_mstr.cs_cat}& {fcs_cs_mstr.cs_id_yr}&{fcs_cs_mstr.cs_num}
So the result should be GV91123456
But the result I'm getting is GV91.00123,456.00
How can I convert the number fields to text fields, if that's what I have to do. I've tried using the ToText function and that didn't work.
Any suggestions??
cs_cat(string) ex. GV
cs_id_yr (number) ex. 91
cs_num (number) ex. 123456
Then I join these together using:
{fcs_cs_mstr.cs_cat}& {fcs_cs_mstr.cs_id_yr}&{fcs_cs_mstr.cs_num}
So the result should be GV91123456
But the result I'm getting is GV91.00123,456.00
How can I convert the number fields to text fields, if that's what I have to do. I've tried using the ToText function and that didn't work.
Any suggestions??