Now that I am thoroughly happy with the TRIM function, I have another issue. One downloaded field has catalog numbers. Unfortunately some are 18 char long with leading zeroes, and some are 10 char long with leading zeros. I just need the last six characters. I have this a s a text field, and need to convert this for easy reading for the staff. Editorial comment: This idiotic program was written in Oracle, is online, and I have no control over the downloads. The "gurus" that I have had contact with have no sense of user friendly applications. Thank Razzak for R:base - at least we have a tool to clean up other's garbage and make it useful. BC
Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [EMAIL PROTECTED]
<<inline: Picture (Device Independent Bitmap) 1.jpg>>
