Jump to content

Join by Left Characters


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. 



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

  • Create New...