remove zero and a point from nvarchar
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Wed Oct 24, 2012 7:24 am
remove zero and a point from nvarchar
Goodmorning. I have a field Nvarchar with length 450. My data is in the form 00000000000000000140. (20 characters including the point (.). I would like to remove all zeros and the point at the end and keep only the 140. If the case is 0000000000000000000. , I need to have 0. Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India