Join by Left Characters

[pwarden@fibermaterialsinc.]

I have two tables that I need to connect but it is not a normal join. 

 

Table 1 Field: ARAT 19-19-19 B

Table 2 Field: ARAT 19-19-19

 

I cannot get these on a normal join because of the "b". I found a code but cannot get the command screen in Crystal Reports to accept it. Can you help?

Here is the code I found

Select Left(RoutingNumber, 13) As ExtractString
From WO1_WorkOrderMaster;

 

Here is the error I am getting back. 

 

Any help is appreciated!!