Sounds like a job for LTRIM: LTRIM (char) char Returns the value of (char) after deleting any blank
spaces and tabs to the left. Change the form so the users a typing their data into a temporary field. Have a filter fire on submit or modify that runs the field through LTRIM and pushes it into the field you are using in the web service J.T. Shyman Column Technologies _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, February 28, 2008 11:50 AM To: [email protected] Subject: Capture Space Value ARS 6.03 patch 16 WIN 2003 SQL2K We recently discovered an interesting phenomenon. We have a character field where users enter free text. This text is passed via a web service to another system. If the user should happen to enter a 'space' as the first character in the string there are two things that happen: * On the Remedy side the field appears to be blank. This is the case even if there is text entered after the 'space'. * In the other system, the mapped column in the WSDL has a value of 10. I need to figure out a way to check the string and see if the first character is indeed a 'space'. The idea will be to either give the user an error message or if possible delete the 'space' from the string. If anyone has a good way to accomplish this I am open to ideas. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

