It could be chr(160) - the literal character for the non-breaking space
( ). Trimming won't cut it out. Instead, try a replace on it.

replace(myString,chr(160),"","ALL")


-nathan strutz
http://www.dopefly.com/


On 6/21/06, Michael E. Carluen <[EMAIL PROTECTED]> wrote:
>
> I'm currently using a UDF that returns a simple alpha-num value.  When
> used
> inside a form textarea, the value generates several leading whitespace
> chars. Wrapping it in trim() doesn't work.  Any suggestions?  Thank you.
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244488
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to