SQL replace question

[anichols]

hello all,

I have this functioning SQL code:

SELECT LOANMAST.BANK, LOANMAST.BRANCH,
       LOANMAST.LOAN_NBR, USERF.USER13A, LOANMAST.POSTDATE, 
       LOANMAST.LOAN_AMT, LOANMAST.SHORT_NAME
--USER13A must say "D" in all rows

FROM LOANMAST LOANMAST
      LEFT OUTER JOIN BORRLIST BORRLIST ON 
     (BORRLIST.BANK = LOANMAST.BANK)
      AND (BORRLIST.BRANCH = LOANMAST.BRANCH)
      AND (BORRLIST.LOAN_NBR = LOANMAST.LOAN_NBR)
      LEFT OUTER JOIN BORROWER BORROWER ON 
     (BORROWER.XUNIQUE = BORRLIST.BORROWER)
      LEFT OUTER JOIN PARTLOAN PARTLOAN ON 
     (PARTLOAN.BANK = LOANMAST.BANK)
      AND (PARTLOAN.BRANCH = LOANMAST.BRANCH)
      AND (PARTLOAN.LOAN_NBR = LOANMAST.LOAN_NBR)
      LEFT OUTER JOIN USERF USERF ON 
     (USERF.BANK = BORRLIST.BANK)
      AND (USERF.BRANCH = BORRLIST.BRANCH)
      AND (USERF.LOAN_NBR = BORRLIST.LOAN_NBR)
      LEFT OUTER JOIN DELINQ DELINQ ON 
     (DELINQ.BANK = USERF.BANK)
      AND (DELINQ.BRANCH = USERF.BRANCH)
      AND (DELINQ.LOAN_NBR = USERF.LOAN_NBR)
      LEFT OUTER JOIN BROKER BROKER ON 
     (BROKER.XUNIQUE = BORRLIST.XUNIQUE)
WHERE ( BORRLIST.XTYPE = 1 )
       AND ( LOANMAST.BANK = 136 )
       AND ( LOANMAST.BPRIN_BAL = 0)
       AND ( LOANMAST.POSTDATE < curDate() )
ORDER BY LOANMAST.POSTDATE DESC

Column #4, I am just trying to replace all the values in the column with "D". I'm struggling to do it correctly, so any help would be greatly appreciated.

 

[Joe4]

Select queries cannot physically update the underlying records (that would be am Update Query).
However, if you just want to return the letter "D" for all records, then simply do a calculated field, returning the hard-coded value of "D", i.e.

SELECT LOANMAST.BANK, LOANMAST.BRANCH,
       LOANMAST.LOAN_NBR, 'D' as [USER13A], LOANMAST.POSTDATE, 
       LOANMAST.LOAN_AMT, LOANMAST.SHORT_NAME
...

 

[anichols]

Brilliant! I've learned something new today. Thank you very much!
<Insert emoji of me tipping my hat to you>

 

[Joe4]

You are welcome.
Glad I was able to help!