Jump to content

Join by Left Characters


pwarden@fibermaterialsinc.
 Share

Recommended Posts

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. 

image.png.52902a2e5e68d25b3e6b8c168ec63637.png

 

Any help is appreciated!!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...