left trim ?

[Mike Hughes]

I have the query below and I want to remove the first 16 leading characters from NOLDBA_NOTES.DESC_NOTE. Right now for that field the query returns
Amount Received:105. 105 is a dollar amount and that is all I want to see. Each record has a different dollar amount. I want to remove AMOUNT RECEIVED: from all the results for that field.
Thanks Mike


SELECT
NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE AS DO,
NOLDBA_INT_CASE_STATUS.WORKER_ID AS WORKER,
NOLDBA_NOTES.DESC_NOTE INTO [TEMP 1]

FROM (NOLDBA_NOTES INNER JOIN NOLDBA_MINOR_ACTIVITY_DIARY ON NOLDBA_NOTES.ID_TOPIC = NOLDBA_MINOR_ACTIVITY_DIARY.ID_TOPIC) INNER JOIN NOLDBA_INT_CASE_STATUS ON NOLDBA_MINOR_ACTIVITY_DIARY.CASE_LIST = NOLDBA_INT_CASE_STATUS.CASE_ID

WHERE (((NOLDBA_NOTES.CD_CATEGORY)="EN") AND ((NOLDBA_NOTES.CD_SUBJECT)="RMDCY") AND ((NOLDBA_NOTES.DESC_NOTE) Like 'AMOUNT RECEIVED*') AND ((NOLDBA_NOTES.DT_BEG_VALIDITY)>=#12/1/2012#))

ORDER BY NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE, NOLDBA_INT_CASE_STATUS.WORKER_ID;

 

[Mike Hughes]

I got it myself. Thanks for looking. Mike