| :: Leading characters :: (1) | Post a New Message | Post a Reply |
 Leading characters | Post a Reply |
since: Nov 17, 2005
from: TX
Is there a way to left trim the field using text replacement? Thanks.
| index | search | no replies | posting guidelines | help | login | register |
| Index » Products » ASP Report Wizard v2 |
| |||||||
| Nov 21 2005, 2:03 PM |
| ||||||
| Katmandu since: Nov 17, 2005 from: TX | We have a string field containing numbers (invoice #) that has leading spaces. We are able to filter a report using the contains function, however, we receive a "no records" response if we use the equal to function. The field length is 10 and most invoice #s have four leading spaces. We tried entering in the leading spaces when using the equal to function to no avail. Is there a way to left trim the field using text replacement? Thanks. | ||||||
| Pages: (1) [1] | |||||||