Removing characters from a string

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65143 More actions · Answer 1

REPLACE('A1EC1XXXXXX-52','X','')

Far away is close at hand in the images of elsewhere.
Anon.

David Burrows SSC Guru Points: 65143 More actions · Answer 2

or

STUFF('A1EC1XXXXXX-52',6,6,'')

if they are not really X's

Far away is close at hand in the images of elsewhere.
Anon.

Dave Bailey SSC Veteran Points: 216 More actions · Answer 3

what I really want to do is drop them so it would read 'A1EC1-52'

David Burrows SSC Guru Points: 65143 More actions · Answer 4

That is what the REPLACE query I posted will do, try this in QA

SELECT REPLACE('A1EC1XXXXXX-52','X','')

and you will get

A1EC1-52

Far away is close at hand in the images of elsewhere.
Anon.

Dave Bailey SSC Veteran Points: 216 More actions · Answer 5

SSC Veteran

Points: 216

November 16, 2005 at 7:51 am

That did the trick, many thanks