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