Hello all..I'm having some difficulty trying to figure out how to delete a space in a field if the first character is a space?
I have a series of loan numbers..but some of them, when imported, have a space as the first character. How could I construct a query to look for those and delete that first character? Any help would be greatly appreciated. Thank you.
I have a series of loan numbers..but some of them, when imported, have a space as the first character. How could I construct a query to look for those and delete that first character? Any help would be greatly appreciated. Thank you.
