BrianFawcett
Registered User.
- Local time
- , 16:13
- Joined
- May 3, 2010
- Messages
- 63
I have a database which is being passed records from another database. The Reference number I am being given has a number of spaces in the value, i.e. - "B25601 - 111128 - 1".
I would like to remove the spaces so the field is "B25601-111128-1".
I know TRIM can be used to remove leading and trailing spaces, can it also be used to remove them from the middle of a string?
I would like to remove the spaces so the field is "B25601-111128-1".
I know TRIM can be used to remove leading and trailing spaces, can it also be used to remove them from the middle of a string?