Display data without leading spaces

[Guest]

I have two fields, one is the customer code and the other is the product
code. Both fields are text fields with a field size of 12. The data in the
fields have leading spaces with data values from 1 to 999999 so there are
from 11 to six leading spaces. How do I format the fields on a query or
report to display the values without the leading spaces?

Thanks,

Scott

 

[Douglas J. Steele]

Use the Trim function:

SELECT Trim(Field1) From MyTable

 

[Jason Lepack]

Scott,

Use the trim() function.

SELECT
Trim(your_field_with_the_spaces)
FROM
you_table

Cheers,
Jason Lepack

 

[Guest]

Worked great! Thank you -

Use the Trim function:

SELECT Trim(Field1) From MyTable

 

[Guest]

Thank you!

Scott,

Use the trim() function.

SELECT
Trim(your_field_with_the_spaces)
FROM
you_table

Cheers,
Jason Lepack