How to remove a string from another string?

Question

I have a string BK1112-7. I want to replace everything after the -, including the -. How do I do that ? REPLACE() checks for a fixed for a fixed pattern. I want the pattern to be "variable".

How can I do this ?

Filipe Silva · Accepted Answer · 2013-12-14 00:41:37Z

2

You can do:

SELECT SUBSTRING('BK1112-7',0,CHARINDEX('-','BK1112-7'));

This will get you the value up until the -.

sqlfiddle demo

To add extra information after that just do + 'replacement'

edited Dec 14, 2013 at 0:41

answered Dec 14, 2013 at 0:25

Filipe Silva

21.7k6 gold badges56 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

M.Ali · Accepted Answer · 2013-12-14 00:39:22Z

1

DECLARE @String NVARCHAR(20); 
SET @String  = 'BK1112-7';

SELECT LEFT(@String, CHARINDEX('-', @String) - 1) + 'ReplacementString'

Result

BK1112ReplacementString

edited Dec 14, 2013 at 0:39

answered Dec 14, 2013 at 0:30

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Collectives™ on Stack Overflow

How to remove a string from another string?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related