Thank you, Pecoflyer! That did the trick. This data was pulled from another program and I didn't even think to check if it had spaces. Duh! I was also unaware of the TRIM function. Thanks! I may have more questions tomorrow as I work on this some more, so I think I will open-up a new thread if so (unless it is better to keep this one going even though it may have a different topic).
|