Joined: 06 Oct 2009
Online Status: Offline
Posts: 39
Topic: Parse leading 0 Posted: 08 Nov 2012 at 10:10am
Have a text report that has a 5 character StreetNumber field. If there are fewer characters than 5 zeros are added.
This works with Access:
SELECT Lastname & ', ' & Firstname AS Name, Replace(LTrim(Replace(StreetNumber, "0", " ")), " ", "0") & ' ' & address AS sAddress, City & ', ' & State & ' ' & zip AS CityStZip, Telephone FROM Customers ORDER BY Lastname, Firstname
However, it is a no go when entered into cr 2008. Any solution?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
