Unanswered: concatenate (possibly) in Interactive SQL
Field name: alternate_id
Table name: basic
A client stores id numbers in the alternate_id field. Some of the id numbers are preceded by 'KW', while others are not. My goal is to write a script in Interactive SQL that will insert 'KW' before the id numbers that do not already contain 'KW'. I am not sure how to write this script. I thought it would be a concatenate, but I don't think so now. Can someone please point me in the right direction? Thank you!