alphanumeric field

[cjany]

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??

 

[lbass]

Try:

{fcs_cs_mstr.cs_cat}& totext({fcs_cs_mstr.cs_id_yr},0,"")&totext({fcs_cs_mstr.cs_num},0,"")

The 0 removes the decimals and the "" removes the comma separator.

-LB

 

[cjany]

That worked. Thank you so much.