Originally posted by Brett Kaiser
EDIT: eek-gadz...I've been [sniped]
Thanks fro the suggestion, but I am still running into some problem. You see, I am trying to only look at the last three characters of these product numbers, but there is thousands of different product #'s to insert the way it's displayed up above.
I also tryed slect right(item_code, 3) and sinse not all items are the same lenght, some records return with blanck spaces and no characters because that item is shorter than others.
Ultimately, I want ti to go to the end of each item and select the last three characters, whether the lenght of the item may be 15 characters or 7 characters.
Thanks again, and like before all the help is appreciated.