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