I have tried several different ways of getting the Left to give me only the data I need. Basically i need to create a table that has 2 fields. One original field and the other one only taking the left so many characters. This way I can link to tables together by using this "new" command table.

Example table one has "ABC" table 2 has "ABCD", i need to created something that will look only at the left 3 characters and link them. So the command i was creating was taking the table that has the "ABCD" and trying to create 2 fields, on that has the full "ABCD" and another field that only takes the left 3 of "ABCD" then i could link my original tables together with the command in the middle.

I hope i am making sense.

Select
left(Sort, 3) AS 'SortQ',
from AP_Vendor;

Here is one example of trying to get just the left 3 from the field.

the error that returns is "Failed to retrieve data from the database. Details: 37000[ProvideX][ODBC Driver] Expected lexical element not found: <identifer> [database vendor code: 1015]

I am needing to do this in Crystal Reports. The data source is a proprietary version from Sage 100. So is there a way to do this in Crystal?   This is why i was trying to create a table using the Command.

What about using DECLARE "DATA" AS CHAR(8)
???

How do i pull out only 8 characters of data from a field using the Command in Data Expert?

Edited by chudok - 05 Aug 2019 at 9:58am

At this point i am even trying to figure out the code for Crystal.

I wish i could drop a screenshot. But this is where i am going. Database tab - database expert - select the connection - the first thing in the connection is Add Command. This is where i am trying to add this left(data) to.

does anyone know if you can create a statement that will only pull the left 8 characters from a field?

Hi,

Just check this SAP note, which may help you to join both tables:

https://apps.support.sap.com/sap/support/knowledge/public/en/1212698