MVSFORUMS.com

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

I have table Employee with two fields
Name[x(20)] and Salary[9(10)]
The data will be as follows

kolusu · Posted: Fri Aug 31, 2007 3:36 am Post subject:

psmadhusudhan,

Try this.

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

Thanks Kolusu.

I have one question, I am not getting mails when a reply is posted for my post even though I am selecting 'Notify me when a reply is posted'.
Can you help me in this.
_________________
Thanks
Madhu Sudhan

kolusu · Posted: Fri Aug 31, 2007 10:30 am Post subject:

bstillwa · Posted: Fri Aug 31, 2007 11:45 am Post subject:

I believe that using REPLACE will replace all occurrences of a dash, so if a name contains a dash in other than the last position, then that dash will also be removed. The question was for only removing a trailing dash.
_________________
Bev.

jsharon1248 · Posted: Fri Aug 31, 2007 12:02 pm Post subject:

Try this:

advoss · Beginner Joined: 23 Aug 2005 Posts: 26 Topics: 0

how about
select left(name,length(name)-1) as name,salary
from table;

or

select substr(name,1,length(name)-1) as name,salary
from table;
_________________
Alan Voss

jsharon1248 · Posted: Fri Aug 31, 2007 12:15 pm Post subject:

Easier yet is the STRIP function.

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

try strip(rtrim(name),t,'-')

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

Thank you all for your replies Very Happy

_________________
Thanks
Madhu Sudhan