Using LEFT function with LEN

Asked May 29 '13 at 14:16

Active May 29 '13 at 14:16

Viewed 56 times

I have the following:

SELECT DISTINCT 
Left(GIFTHEADER.pID + GIFTHEADER.PID + '-' + Cast(PAYMENTDETAIL.PLINENO as Varchar),18)
AS TRANSACTIONREF...

Currently my value looks like this:

ABC0005953ABC0005953

I want to simply strip off the first 4 characters from GIFTHEADER.pID

asked May 29 '13 at 14:16

PriceCheaperton

Yes, but i need to delete that old question. – PriceCheaperton May 29 '13 at 14:18
2

why? you asked about 4 there in comments and you got answers – gbn May 29 '13 at 14:19

0 Answers0