1
Reply

select only upto second '-' only

JAYRAM

JAYRAM

Dec 10 2013 2:06 AM
865
I Have table like this......


House_no

6-1
6-1-2
6-1/2
6-1/78
6-12/5
6-3-124 ,hyderabad
6-3/2
6-3-19876 ,yuyu

select only first '-' only.............

I WANT OUTPUT LIKE THIS...........

6-1
6-1/2
6-1/78
6-3/2
6-12/5







Answers (1)