delete from certain point.

estefex · #1 (**permalink**) 04-30-04, 13:57

How would I be able to delete everything after the "/" from a sample column listed below. Everything from the "/" and after in not suppose to be in the column.

Column A

A32916/917
A33649/650
DUPONT2/10/0
A37154/37152
A37154/37152
A35419/35422

Pat Phelan · #2 (**permalink**) 04-30-04, 14:52

String handling functions in SQL are pretty engine specific. Since you regularly post in the MS-SQL forum, I'll assume that is what you plan to use, so I'd suggest:

Code:

SELECT Left([Column A], CharIndex([Column A], '/') - 1)
   WHERE [Column A] LIKE '%/%'

-PatP

Nocopy · #3 (**permalink**) 05-02-04, 17:36

If I did it in Oracle I would have used UPDATE instead of SELECT.

Now in SQL server it may be different.

r937 · #4 (**permalink**) 05-02-04, 18:24

LOL

Nocopy · #5 (**permalink**) 05-02-04, 19:17

r937
Glad you liked it.
I looked at your rudy.
You the Shit.

r937 · #6 (**permalink**) 05-02-04, 19:20

thank you

nicest compliment i've had all week

Internet Services

Web Development

Digital Marketing

Consumer Tech