Crystal Reports SQL Command Convert Text To Number

Message

   Hello.

I have an issue where I need to link two tables from two different datasources - the problem is, the Account ID in one datasource is type String, while in the other it is type Number.

I've played around with commands, but I can't get the String to convert to Number.

Another problem is that the Account ID is really made up of two fields in one database, while they combined them in the other.

As an example, in database A, the Account ID is a String, and Field 1 = 123456789.

But in database B, the Account ID is a Number, and Field 1 = 12345, and Field 2 is 6789.

Any idea on how I can get these to link.  I've been mildly successful converting the Number to String, but I'd prefer to convert the String to Number.

Another problem I have (and please understand I've done some minimal stuff with Commands but am by no means an expert) - whenever I create the Commands to be able to link these tables, my report will run REALLY, REALLY slow.  Any suggestions?

Any ideas on any of these issues would be appreciated!  Thanks, Mike