Below is a result set ...I need to update Code_Name with a prefix (Code) and a hypen. I've tried a variety of statements on my own with no luck.
I'd want the result to look like this...
32 -Home Health-Inpatient
33 -Home Health-Outpatient
34 -Home Health-Other