MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

I have a db2 table called as "Emptable" with 5 fields.

rollno - 10
Name - 25
halltino - 10
adress - 25
pincode - 10
....

My requirement is:

If there is a space in Halltino, remove the part after space.

Ex:

1)if Halltino='1234 56789' remove the value after space.then it will be halltino='1234'
2)if Halltino='1 3456789' remove the value after space.then it will be halltino='1'
3)if Halltino='1 3 56789' remove the value after space.then it will be halltino='1'

Could any one pls. tell me the query to get this.

Regards
nadh

kolusu · Posted: Wed Jul 12, 2006 4:23 am Post subject:

nadh,

Try this

Jaya · Posted: Wed Jul 12, 2006 5:18 am Post subject:

Nadh,

Please try this...

Jaya · Posted: Wed Jul 12, 2006 5:24 am Post subject:

oops!!...The solution is already posted. I forgot to click the submit button earlier. Sad

Jaya..
_________________
"Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein