help need

[#1]

hi friends, i want to select 7 numbers among 8 number code.

ex: 08786543 so i want to select only 0878654 to compare to another table column values because it s code in 7digits. please help

LOAD BASE_PRICE as original_price,

   CATALOG_NO as Item

FROM

(qvd);

here CATALOG_NO is in 8 digit code

LOAD [Item Number] AS Item

FROM

(qvd);

here  [Item Number] is in 7 digit code

[albertovarela]

If it's the first 7 characters use this:

LOAD BASE_PRICE as original_price,

   left(CATALOG_NO,7) as Item

FROM

(qvd);

[#3 · Accepted solution]

Hi,

Might be smething like this:

LOAD BASE_PRICE as original_price,

   Left(CATALOG_NO,7) as Item

FROM

(qvd);

And the second remais the same:

LOAD [Item Number] AS Item

FROM

(qvd);

But this is good when you want first 7 digit always.

Hope this helps!

[#4]

thanks friends

[#5]

Hi,

If you have got the solution, can you please close the thread by marking correct/helpful answer so it is easier for everyone to identify the solution.