January 23rd, 2003, 02:31 PM
|
|
|
|
Join Date: Apr 2007
Posts: 25
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
What to use, REPLACE ?
Ok,
here is what I created:
Code:
INSERT INTO test VALUES (1,'M:I:B:AA');
INSERT INTO test VALUES (2,'M:I:B:BB');
INSERT INTO test VALUES (3,'M:I:B:CC');
INSERT INTO test VALUES (4,'M:I:B:DD');
INSERT INTO test VALUES (5,'M:I:B:EE');
INSERT INTO test VALUES (6,'M:I:B:FF');
INSERT INTO test VALUES (7,'M:I:B:GG');
INSERT INTO test VALUES (8,'M:I:B:HH');
.....
The smiley face shouldn't be there in line 4, obviously, it should be : D (without the space).
What I want to do is take out the 5th and 6th characters in all rows in the second column( e.g. B: ) and leave the rest of the data alone. I would like to replace the specific positions(5th and 6th) as I do not know if B: would come up again.
I have tried using various replace statement with no luck. Am I using the right statement? How would I do this?
TIA
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
(smiley face intentional!) worked like a charm. 
Linear Mode
