wedd
05-05-2011, 02:14 AM
Hi, I have table with a column called C_Customers which displays a record of numbers in these formats 000 000 and
000 000 000. Is there a formula, trim function or space function or any other function I use in the query design to remove spaces or join the numbers together? In other words the final display of the numbers in the column should show 000000 and 000000. Can this be done? If so, how can this be done? Would you have any examples to show how this is done.
Thanks for your contributions :friends:
000 000 000. Is there a formula, trim function or space function or any other function I use in the query design to remove spaces or join the numbers together? In other words the final display of the numbers in the column should show 000000 and 000000. Can this be done? If so, how can this be done? Would you have any examples to show how this is done.
Thanks for your contributions :friends: