selecting first 5 numbers of a value and matching them with another column
hi folks,i want to do a new column, if the first 5 digits in batch_id are the same as the first 5 in batch_id_1 then true else false.I can do the if statement but not sure how to select the first 5 digits.