I am trying to reset columns with a character ("<") to numeric and retain the "<" in another column
Hi - I have a table with columns that are made up of lab results (numeric values) that were entered as a text string. They are text string because some have a "<" in front of the numeric value. I need to be able to perform numeric calculations on the values so I am trying to remove the "<" symbol and place it in a new column that is named "ORIGCOLNAME_QUALIFIER" (where ORIGCOLNAME is the name of...